Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Ron--tried this today...perfect. Once again, thank you for your brilliance.
Have a great day, Pam "Pam M" wrote: 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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Programming | Excel Discussion (Misc queries) | |||
Excel/VBA programming | Excel Discussion (Misc queries) | |||
Excel Programming help | Excel Worksheet Functions | |||
Very New in Excel Programming | Excel Programming | |||
Excel Programming | Excel Programming |