View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pam M Pam M is offline
external usenet poster
 
Posts: 65
Default excel programming

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?