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

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