LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 75
Default outlook draft email

From VBA, I am creating a draft email via the following:

Set Outlook = CreateObject("Outlook.Application")
Set SendItem = Outlook.CreateItem(olMailItem)

With SendItem
.Subject = Subject
.HTMLBody = strBody
.Save
End With

Set SendItem = Nothing
Set Outlook = Nothing


This works great, except for a couple of users. Their email goes to their
Inbox instead of their Drafts folder. Is there a way to force the message
to be saved in the drafts folder?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
attach outlook email rwtrader Excel Discussion (Misc queries) 1 April 6th 09 10:49 PM
How do I set up Outlook email? new at outlook set up New Users to Excel 2 March 5th 09 08:31 AM
Saving a draft only when outlook is open Brad Excel Discussion (Misc queries) 0 April 21st 08 04:56 PM
Outlook Email Jame-O New Users to Excel 1 November 7th 06 05:53 PM
Email & Outlook Chris Excel Discussion (Misc queries) 0 March 14th 06 12:04 PM


All times are GMT +1. The time now is 11:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"