L
Lisa B.
I would like to do a MS Word mail merge using excel as the data source
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 then
merge with my word document. My concern is that each recipient get
the correct (individualized) page, along with the cover sheet.
Is is possible to embed a file (pdf or word) into an excel cell? That
way, i could use the excel file to set up the merge (Name1, Fax
Number1, Document 1; Name2, Fax Number,2 Document 2; Name3, Fax
Number3, Document3) and then merge with my cover sheet. The merged PDF
would then become the second page of the word document.
Will this work? If not, anyone else have another way to do this?
Feel free to respond offline if you prefer.
Lisa Berger
New York City
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 then
merge with my word document. My concern is that each recipient get
the correct (individualized) page, along with the cover sheet.
Is is possible to embed a file (pdf or word) into an excel cell? That
way, i could use the excel file to set up the merge (Name1, Fax
Number1, Document 1; Name2, Fax Number,2 Document 2; Name3, Fax
Number3, Document3) and then merge with my cover sheet. The merged PDF
would then become the second page of the word document.
Will this work? If not, anyone else have another way to do this?
Feel free to respond offline if you prefer.
Lisa Berger
New York City