View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lisa B. Lisa B. is offline
external usenet poster
 
Posts: 1
Default Insert files (pdf, word doc) in excel cell

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.

Anyone else have another way to do this?

Feel free to respond offline if you prefer.

Lisa Berger
New York City