Thread: Direct mail merge documents to drafts folder
View Single Post
  #7  
Old January 13th 16, 05:19 PM
David Meek David Meek is offline
Junior Member
  
First recorded activity at Outlookbanter: Jan 2016
Posts: 1
Default
Quote:
Originally Posted by Edward View Post
Hi everyone,
I use mailmerge in word to create email messages for different recipients
but the problem i have is after I create the merged document it automatically sends the emails to each recipient I wonder if there is way to send those emails to my drafts folder because I want to attach some files o each email and then send them manually, It's okay if the soultion needs VBA becasue I'm familiar with VBA .
--
Best regards,
Edward
The simplest way to accomplish this is to un-check the 'Send Immediately when Connected' option - found under Outlook Options Advanced Send and Receive.

Then perform your mail-merge as usual, and the emails will be created in your Outbox. Simply drag them from there to your Drafts folder, and attach your files.

Cheers,
Dave.
Ads