Mail Merge with pdf as second page
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
|