Sending Word Attachment Using a Macro
 

I am using a Macro to email several addresses at once. The problem is that
the file i want to send is in word and it is too complicated to recreate in
excel. What is the VBA code to do this (if there is one). I know the exact
location of the file on my pc, i just dont know how to tell VBA where it is.

Any help would be really appreciated

Thanks

Andy

Sending Word Attachment Using a Macro
 

Hi Andy

If you use Outlook then see the outlook object model examples on my site
http://www.rondebruin.nl/sendmail.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Andy@HycoMan" wrote in message ...
I am using a Macro to email several addresses at once. The problem is that
the file i want to send is in word and it is too complicated to recreate in
excel. What is the VBA code to do this (if there is one). I know the exact
location of the file on my pc, i just dont know how to tell VBA where it is.

Any help would be really appreciated

Thanks

Andy