Solved

VBA to place an email into your draft folder

Posted on 2010-09-14
4
896 Views
Last Modified: 2012-05-10
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
Comment
Question by:CFMI
  • 2
4 Comments
 
LVL 59

Expert Comment

by:Chris Bottomley
Comment Utility
WHat code are you using generally to create the email?

Chris
0
 
LVL 92

Expert Comment

by:Patrick Matthews
Comment Utility
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
 
LVL 92

Accepted Solution

by:
Patrick Matthews earned 500 total points
Comment Utility
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
 
LVL 1

Author Closing Comment

by:CFMI
Comment Utility
Works well - Thank you!!!
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Granting full access permission allows users to access mailboxes present in their database. By giving full access permission one can open and read the content of any mailbox but cannot send emails from that mailbox.
Outlook Free & Paid Tools
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now