See the article "Mail Merge to E-mail with Attachments" at
http://word.mvps.org/FAQs/MailMerge/...ttachments.htm
--
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP
"Lisa B." wrote in message
...
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