Hi Pam
You need other code to do this
Do you use Outlook ???
"Pam M" schreef in bericht
...
I have a macro that sends an automatic email from Excel to notify that a
file
needs to be reviewed.
Application.Dialogs(xlDialogSendMail).Show _
arg2:="MIX REQUEST: " & [JobName] & ".xls", arg3:=True
This places the filename of the file that needs to be reviewed into the
subject. Because it is going straight from excel, it also attaches the
file.
Which argument in DialogSendMail should be marked false so that the
attachment doesn't go and just the email does?
__________ Information from ESET Smart Security, version of virus
signature database 4285 (20090728) __________
The message was checked by ESET Smart Security.
http://www.eset.com
__________ Information from ESET Smart Security, version of virus signature database 4285 (20090728) __________
The message was checked by ESET Smart Security.
http://www.eset.com