• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 933
  • 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 BottomleySoftware Quality Lead EngineerCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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