• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 921
  • Last Modified:

VBA to place an email into your draft folder

Is there VBA to place an email inside my MS Outlook DRAFT folder to double check attachments before emailing specific managers?  My current code automatically emails to the managers but I need to double check before sending so  I am using .
To = DLookup("EmailAddress", "TblEmailPayTemp")
Is there a VBA statement that addresses the "To"  but places the email into a draft folder?
0
CFMI
Asked:
CFMI
  • 2
1 Solution
 
Chris BottomleyCommented:
WHat code are you using generally to create the email?

Chris
0
 
Patrick MatthewsCommented:
CFMI,If you are using Access's SendObject method, then you can pass True for the EditMessage argument; that will bring up the message in an Outlook inspector and thus allow you to review before sending.If you are automating Outlook to send the message, instead of using:    olMsg.Sendto send the message, use:    olMsg.Displayto review/edit the message.Patrick
0
 
Patrick MatthewsCommented:
If you are automating Outlook and you simply want to save each message to Drafts so you can review them later, instead of using:    olMsg.Senduse:    olMsg.Close 0 '0 = olSaveThat saves the messages to your Drafts folder without sending them.
0
 
CFMIFinancial Systems AnalystAuthor Commented:
Works well - Thank you!!!
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now