Save a file and send as an email - written into macro

[Louise Semaj]

I am wanting code to to save a file and then automatically
fire up outlook and insert the file with specified email
addresses ready to be sent.

Any hints on the code to use.

Cheers

 

[Tom Ogilvy]

See information at these sites: (if sending as an attachment, look at help
on sendmail)

Ron de Bruin's site

http://www.rondebruin.nl/sendmail.htm
http://www.rondebruin.nl/index.html

an Article by Ron on MSDN:
http://msdn.microsoft.com/library/en-us/odc_xl2003_ta/html/odc_xlmail.asp

Dick Kusileka's site
http://www.dicks-clicks.com