Help!

Set Default Path for Inserting an Attached File

 
  

Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Programming VBA RSS
Next:  VBA Editor will no longer open  
Author Message
JR_06062005
External


Since: Aug 02, 2007
Posts: 2



PostPosted: Thu Aug 02, 2007 6:32 am    Post subject: Set Default Path for Inserting an Attached File
Archived from groups: microsoft>public>outlook>program_vba (more info?)

I have saved an email as a message file (e.g., MyEmail.msg). In the same
folder where this file is saved, I have an Excel file which I periodically
update. When I open the message file, I then attach the Excel file. But the
message file opens to my default folder for Outlook (e.g., My Documents).

Is there a way to reset the default path for this message so that when I
insert the Excel file the dialogue opens to the folder where the Excel file
resides (My Documents/folder/)?
Back to top
Sue Mosher [MVP-Outlook]
External


Since: Feb 11, 2005
Posts: 21627



PostPosted: Thu Aug 02, 2007 9:57 am    Post subject: Re: Set Default Path for Inserting an Attached File [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

A particular message doesn't have a default attachment path associated with it, and the Attach File dialog that Outlook shows has no programmability features.

If you have Windows Explorer open so you can open the message file, why not just drag the Excel file from that window into the open message?

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"JR_06062005" <JR06062005.RemoveThis@discussions.microsoft.com> wrote in message news:98BF3962-4824-40E4-BD97-C49906301A25@microsoft.com...
>I have saved an email as a message file (e.g., MyEmail.msg). In the same
> folder where this file is saved, I have an Excel file which I periodically
> update. When I open the message file, I then attach the Excel file. But the
> message file opens to my default folder for Outlook (e.g., My Documents).
>
> Is there a way to reset the default path for this message so that when I
> insert the Excel file the dialogue opens to the folder where the Excel file
> resides (My Documents/folder/)?
Back to top
JR_06062005
External


Since: Aug 02, 2007
Posts: 2



PostPosted: Thu Aug 02, 2007 9:57 am    Post subject: Re: Set Default Path for Inserting an Attached File [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

That works. One more question, can I set the default path for a form?

"Sue Mosher [MVP-Outlook]" wrote:

> A particular message doesn't have a default attachment path associated with it, and the Attach File dialog that Outlook shows has no programmability features.
>
> If you have Windows Explorer open so you can open the message file, why not just drag the Excel file from that window into the open message?
>
> --
> Sue Mosher, Outlook MVP
> Author of Microsoft Outlook 2007 Programming:
> Jumpstart for Power Users and Administrators
> http://www.outlookcode.com/article.aspx?id=54
>
>
> "JR_06062005" <JR06062005.RemoveThis@discussions.microsoft.com> wrote in message news:98BF3962-4824-40E4-BD97-C49906301A25@microsoft.com...
> >I have saved an email as a message file (e.g., MyEmail.msg). In the same
> > folder where this file is saved, I have an Excel file which I periodically
> > update. When I open the message file, I then attach the Excel file. But the
> > message file opens to my default folder for Outlook (e.g., My Documents).
> >
> > Is there a way to reset the default path for this message so that when I
> > insert the Excel file the dialogue opens to the folder where the Excel file
> > resides (My Documents/folder/)?
>
Back to top
Sue Mosher [MVP-Outlook]
External


Since: Feb 11, 2005
Posts: 21627



PostPosted: Thu Aug 02, 2007 10:35 am    Post subject: Re: Set Default Path for Inserting an Attached File [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Same thing: A form is a message (a special type that acts as a template). A message has no default attachment path.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"JR_06062005" <JR06062005.DeleteThis@discussions.microsoft.com> wrote in message news:1540B3CE-7572-4F36-9C79-6743ACF7D815@microsoft.com...
> That works. One more question, can I set the default path for a form?
>
> "Sue Mosher [MVP-Outlook]" wrote:
>
>> A particular message doesn't have a default attachment path associated with it, and the Attach File dialog that Outlook shows has no programmability features.
>>
>> If you have Windows Explorer open so you can open the message file, why not just drag the Excel file from that window into the open message?
>>
>>
>> "JR_06062005" <JR06062005.DeleteThis@discussions.microsoft.com> wrote in message news:98BF3962-4824-40E4-BD97-C49906301A25@microsoft.com...
>> >I have saved an email as a message file (e.g., MyEmail.msg). In the same
>> > folder where this file is saved, I have an Excel file which I periodically
>> > update. When I open the message file, I then attach the Excel file. But the
>> > message file opens to my default folder for Outlook (e.g., My Documents).
>> >
>> > Is there a way to reset the default path for this message so that when I
>> > insert the Excel file the dialogue opens to the folder where the Excel file
>> > resides (My Documents/folder/)?
>>
Back to top
Jaegar-Croft



Joined: Sep 04, 2009
Posts: 9



PostPosted: Sat Sep 05, 2009 6:16 pm    Post subject: [Login to view extended thread Info.]

This is how you change the default path for inserting a file ...

1. Click Start, and click Run. (XP) .... OR Start and use the Start Search Box (Vista)

2. type regedit, and then click OK.

3. Locate the following registry key:
HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\User Shell Folders

4. Double-click Personal in the right pane.

5. Change the value to the path you want. For example:
C:\My Attachments, would set the location to the My Attachments folder.
%USERPROFILE%\My Documents, would set it to the My Documents folder on a computer that had more than one user profile.

For Example: I changed mine to I:\ ... so it will open to my external drive.

6. On the Registry menu, click Exit.

7. Restart Outlook.
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Programming VBA All times are: Eastern Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum