Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Email Sent or Cancelled
Please help, I have some code (see below) to send emails from Excel 2003. I have it set with .display because the user needs the option to view the email before sending. My problem is I can't tell if the user sent the email or closed the window without sending. I really need to test to see if the email was sent or not. Any ideas? Thanks in advance, Michael Set OutApp = CreateObject("Outlook.Application") Set outmail = OutApp.CreateItem(0) With outmail ..To = "" ' Environ("username") ..CC = "" ..BCC = "" ..Subject = "" ..Body = "" ..attachments.Add ActiveWorkbook.FullName ..display 'work around for the Outlook security warning message Application.Wait (10) SendKeys "^{Enter}", 5 End With Set outmail = Nothing Set OutApp = Nothing -- mjamici ------------------------------------------------------------------------ mjamici's Profile: http://www.excelforum.com/member.php...o&userid=24337 View this thread: http://www.excelforum.com/showthread...hreadid=379372 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Email Sent or Cancelled
Hi Michael
Only way to be sure is to put your address in the CC -- Regards Ron de Bruin http://www.rondebruin.nl "mjamici" wrote in message ... Please help, I have some code (see below) to send emails from Excel 2003. I have it set with .display because the user needs the option to view the email before sending. My problem is I can't tell if the user sent the email or closed the window without sending. I really need to test to see if the email was sent or not. Any ideas? Thanks in advance, Michael Set OutApp = CreateObject("Outlook.Application") Set outmail = OutApp.CreateItem(0) With outmail To = "" ' Environ("username") CC = "" BCC = "" Subject = "" Body = "" attachments.Add ActiveWorkbook.FullName display 'work around for the Outlook security warning message Application.Wait (10) SendKeys "^{Enter}", 5 End With Set outmail = Nothing Set OutApp = Nothing -- mjamici ------------------------------------------------------------------------ mjamici's Profile: http://www.excelforum.com/member.php...o&userid=24337 View this thread: http://www.excelforum.com/showthread...hreadid=379372 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Macro how to create email link for the email addresses in aRange or Selection | Excel Worksheet Functions | |||
Hyperlink operation cancelled.... | Excel Discussion (Misc queries) | |||
send wkbk as an email attachment with an email address copied from | Excel Discussion (Misc queries) | |||
countif Column A and excule column B if it's cancelled | Excel Worksheet Functions | |||
program stuck at "Save Cancelled by Operator" | Excel Discussion (Misc queries) |