View Single Post
  #4  
Old November 14th 07, 02:17 PM posted to microsoft.public.outlook.program_vba
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default Direct mail merge documents to drafts folder

You can't. You would need to use Outlook automation, not Word mail merge, to create individual messages and attach the files.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Edward" wrote in message ...
Thanks JP but how is it possible to use attachment during mailmerge ? I want
to attach a specific file to each email lets say for Mr. X attach X.pdf and
Mr. Y attach Y.pdf ,...
--
Best regards,
Edward


"JP" wrote:

Why not use VBA to attach the files to the email? There's an
Attachments.Add property in Outlook, there should be similar property
in Word.


HTH,
JP

On Nov 13, 6:36 pm, Edward wrote:
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 thoses
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 Im
familiar with VBA .
--
Best regards,
Edward




Ads