Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm using a line like this to allow the user to easilty send me an
email: Application.Dialogs(xlDialogSendMail).Show ", "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 ", "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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dialogs(xlDialog...).Show arguments usage | Excel Programming | |||
Application.Dialogs(xlDialogPrint).Show - prints too soon | Excel Discussion (Misc queries) | |||
returning values application.dialogs(...).show | Excel Programming | |||
Application.Dialogs(xlDialogSendMail).Show | Excel Programming | |||
Problems with application.Dialogs(xlDialogFormulaFind).Show | Excel Programming |