View Single Post
  #1   Report Post  
AS
 
Posts: n/a
Default mail merge with attachments

Hello,

I found this article with details on a macro to have an attachment with a ma
il merge:

http://word.mvps.org/faqs/mailmerge..Attachments.htm

It works nicely if you just run the macro but if you want to merge fields in
a mail merge document itself it will not do it.
I guess the part I am not getting is, I would like to run the mail merge and
have the macro run after the fields are populated in the word document. Th
is would fill the fields required with the pertinent information then attach
the applicable attachment.
By just running the macro, the mail merge runs and attaches the document but
the fields in the word document only show the merge fields (not actual valu
es).
Does anyone know how to do this? The document says:


'Then execute the mail merge that you want to send out by email with the att
achments and with the result of execution of that mail merge on the screen,
run a macro containing the following code. When the File open dialog appear
s, select the file containing the table created by the catalogue type mail m
erge.'

From the sounds of this, the mail merge should run as normal then call up th
e macro to add the attachment. But, in my case, the mail merge runs without
calling up this macro - any ideas?