Copy folder name for new email
 

I've only recorded macros in excel and edited them afterwards so I'm a bit
limited. I'd like to create a macro that would automatically enter a folder
name in the subject line of a new email. I have about 100 project folders
that are named with a project number and name. Having this information in the
subject line of an email is very important to me, so when I start a new email
I right click on a project folder, pick Rename, hit Ctrl-C, click the subject
line of the new email, hit Ctrl-V, type in a dash and then enter my subject.
It would be great if a new email would propt me to select a folder...
Thanks in advance for any help on this subject.

Copy folder name for new email
 

You can create a procedure that calls the Pickfolder function. If it returns
an object then write its name into
Application.ActiveInspector.CurrentItem.Subject.

Make that procedure Public, then you can create a button on your e-mail's
toolbar for it.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.VBOffice.net --

Am Tue, 5 Dec 2006 06:29:01 -0800 schrieb PDan:

I've only recorded macros in excel and edited them afterwards so I'm a bit
limited. I'd like to create a macro that would automatically enter a
folder
name in the subject line of a new email. I have about 100 project folders
that are named with a project number and name. Having this information in
the
subject line of an email is very important to me, so when I start a new
email
I right click on a project folder, pick Rename, hit Ctrl-C, click the
subject
line of the new email, hit Ctrl-V, type in a dash and then enter my
subject.
It would be great if a new email would propt me to select a folder...
Thanks in advance for any help on this subject.