Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Auto Email from Excel doesn't appear in Sent Items
When I email a Excel file using VBA code, the e-mail appears in my
Outbox but disappears once it has been sent. It does not show up in my Sent Items. This only happens with e-mails sent through this code. I use the code ActiveWorkbook.SendMail Sheets("program").Range("f10").Value, _ "For your approval" With ActiveWorkbook ..Saved = True ..Close Can somebody please explain how I can fix this ? Many thanks for your help. WimR |
#2
|
|||
|
|||
I have no idea if .SendMail sends using your email client. (From your post, it
doesn't sound like it.) But depending on what you use for an email client, you may want to look at: Ron de Bruin's site: http://www.rondebruin.nl And Dick Kusleika's site: http://dicks-clicks.com/excel/olAutomating.htm Both of these guys have lots of sample code for automating Outlook. If this doesn't help, you may want to post back with what email client you're using. Maybe someone can jump in and give you a good answer. WimR wrote: When I email a Excel file using VBA code, the e-mail appears in my Outbox but disappears once it has been sent. It does not show up in my Sent Items. This only happens with e-mails sent through this code. I use the code ActiveWorkbook.SendMail Sheets("program").Range("f10").Value, _ "For your approval" With ActiveWorkbook .Saved = True .Close Can somebody please explain how I can fix this ? Many thanks for your help. WimR -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
how to turn off email header with excel workbook | Excel Discussion (Misc queries) | |||
Auto date changing in Excel is maddening | Charts and Charting in Excel | |||
Can I get email alerts when dates in excel are nearing? | Excel Discussion (Misc queries) | |||
auto save in office excel 2003 | Excel Discussion (Misc queries) |