Hi, I have the following code:

With Application.Dialogs(xlDialogSendMail)
.Show
.To = "
.Subject = "New Set-Up required"
.Body = "Please attach additional documents if appropriate and send the
email as normal."
.Attachments.Add ActiveWorkbook.FullName
End With

But the To, Subject and Body fields do not populate with the fields that I
have specified. I am very new to this so any suggestions would help hugely!!

Many thanks
Jas

You might want to post in an Excel group, since they'll be more familiar with coding the dialogs you're referring to.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Jas" wrote in message ...
Hi, I have the following code:

With Application.Dialogs(xlDialogSendMail)
.Show
.To = "
.Subject = "New Set-Up required"
.Body = "Please attach additional documents if appropriate and send the
email as normal."
.Attachments.Add ActiveWorkbook.FullName
End With

But the To, Subject and Body fields do not populate with the fields that I
have specified. I am very new to this so any suggestions would help hugely!!

Many thanks
Jas

Have a look at Ron's website, he has created an addin for sending mail
from Excel

http://www.rondebruin.nl/mail/add-in.htm

Joop