Email in Outlook Macro needed...

[swade730]

Hello,

Does anyone have a code for opening up a new email message in outlook with a subject saying "Hello, Here are the updates" and the body would have a message that reads "please see attachments"

I want to add it as a button in excel.

Any help would be greatly appreciated

Thank You

[NickyC]

Hi
try this macro
note you can use the macro to add attacments too if it is always the same file, and recipients if they are always the same
To run one program from another using VBA, its reference must be accessible. In the VBA area (alt+F11) select tools > references and scroll down until you see microsoft outlook 14 (or relevant number), then check this box

Please Login or Register  to view this content.