G
Greg Lovern
I'm using a line like this to allow the user to easilty send me an
email:
Application.Dialogs(xlDialogSendMail).Show "(e-mail address removed)", "My
subject"
But it automatically attaches an Excel workbook file. With some older
versions of Excel (I don't recall which versions), I was able to
delete the attachment with sendkeys:
SendKeys "{TAB}{TAB}{TAB}{DELETE}"
Application.Dialogs(xlDialogSendMail).Show "(e-mail address removed)", "My
subject"
But that doesn't work anymore, at least not since Excel 2003.
Is there a way to get rid of that attachment, without the user needing
to manually delete it?
Thanks,
Greg
email:
Application.Dialogs(xlDialogSendMail).Show "(e-mail address removed)", "My
subject"
But it automatically attaches an Excel workbook file. With some older
versions of Excel (I don't recall which versions), I was able to
delete the attachment with sendkeys:
SendKeys "{TAB}{TAB}{TAB}{DELETE}"
Application.Dialogs(xlDialogSendMail).Show "(e-mail address removed)", "My
subject"
But that doesn't work anymore, at least not since Excel 2003.
Is there a way to get rid of that attachment, without the user needing
to manually delete it?
Thanks,
Greg