[Graham Mayor]

You could insert the extra column with the filename of the PDF and provided
the PDF contains only one page - objects cannot span pages in Word - then
the aforesaid method should work. You would just need to additionally supply
all the PDFs and change the command as follows

{ LINK AcroExch.Document.7 "{Mergefield PDFName}" "" \a \f 0 \p }

The PDFs would need to be in the same folder as the merge document or you
would need to add the path (that they will occupy when merged) also.

{ LINK AcroExch.Document.7 "C:\\Path\\{Mergefield PDFName}" "" \a \f 0 \p }

You can test this by merging to a new document then updating the link fields
in that document (CTRL+A then F9). If it works for you could probably merge
to fax yourself.

It works here in principle.

--

Graham Mayor - Word MVP

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




Lisa B. wrote:
Hi Graham,

Thanks for your help. I'm not sure I adequately (or correctly)
explained what I'm trying to do. We are a nonprofit that needs to
send out a questionaire (word document) to about 400 - 500 people to
update our database, and include their page to update along with the
letter/questionaire. We plan to use a fax blast service, to avoid
having to hand fax each questionaire as we did last year.

I need to supply the fax service with the word document (letter/
questionaire) and the source file (excel or access) so they can fax to
correct source. The fax service will "do" the actual merge.

My thought was to add a column to the excel document, and insert the
pdf file: (columns -- Name/Fax Number/PDF) so it is just another
field on the mail merge document. That way the output merge would
contain the document with the correct pdf as page two (or whatever).

Not sure your idea would work, but perhaps I'm wrong.

Any other ideas? I asked the same question in the excel group.

Best,
Lisa


On Mar 27, 2:37 am, "Graham Mayor" wrote:
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 sitewww.gmayor.com
Word MVP web sitehttp://word.mvps.org