ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   outlook draft email (https://www.excelbanter.com/excel-programming/310662-outlook-draft-email.html)

Erin

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?


All times are GMT +1. The time now is 04:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com