Open up a new blank mail dialog box from Excel using vba

  • Thread starter Thread starter Michelle
  • Start date Start date
M

Michelle

Hi,

I would like to use Excel that runs a macro to open up a
new mail in Outlook. I would also like to put in a
generic body message and subject line, but they would
have to be able to pick who they would like to email it
to as it different everytime. I can only do this if they
were sending the file along with it, but is there anyway
of doing this without attaching the file?

Any help would be much appreciated.

Michelle
 
you can automate opening a predefined Email Message or use code to creat the
message and add the subject and body information...
 
Back
Top