Send Email

[PeterM]

I need to send a workbook via our company email service, GroupWise. I'm
currently using Application.Dialogs(xlDialogSendMail).Show which opens
GroupWise and creates a clean email with the workbook attached...this is
great.

However, I need to place a subject and body text into the email for the
user as a template. In Access, I used the Docmd.SendObject statement which
works great but that's not available in VBA for Excel.

Is there another way to create an email with the workbook attached and set
the subject and body text?

Thanks in advance for your help!

 

[jatman]

See Ron de Bruin's site @ http://www.rondebruin.nl/tips.htm

lots, and lots and lots of useful tips, tricks and code

jat