View Single Post
  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Mail Merge with pdf as second page

You could probably conditionally insert a PDF object in your merge document.
Insert a link to the object and wrap it in the field construction. You would
end up with something like:

{ IF{ Mergefield Fieldname } = "Condition" "{ LINK AcroExch.Document.7
"D:\\Path\\Filename1.pdf" "" \a \f 0 \p }" "{ LINK AcroExch.Document.7
"D:\\Path\\Filename2.pdf" "" \a \f 0 \p }" }

This would insert filename1.pdf when the condition is met and filename2.pdf
when not.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




Lisa B. wrote:
I would like to do a mail merge inserting different PDFs as page two
of the word document for a fax blast. However, I need to send a
specific page to a specific fax number. I was thinking of setting up
an excel document with [name, fax number, document] columns as the
data source, and thenmerge with my word document. My concern is that
each recipient get the correct (individualized) page, along with the
cover sheet with the correct name and fax number.

Is is possible to embed a file (pdf or word) into an excel cell? That
way, i could use an excel file to set up the merge (Name1, FaxNumber1,
Document 1; Name2, Fax Number,2 Document 2; Name3, FaxNumber3,
Document3) and then merge with my cover sheet. The individual PDF's
would be the last page of the word document.

Anyone else have another way to do this?

Feel free to respond offline if you prefer.

Lisa Berger
New York City