ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Insert files (pdf, word doc) in excel cell (https://www.excelbanter.com/excel-discussion-misc-queries/181435-insert-files-pdf-word-doc-excel-cell.html)

Lisa B. March 26th 08 11:47 PM

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

dimm March 27th 08 12:03 AM

Insert files (pdf, word doc) in excel cell
 
I dont know anything about the mail merge Lisa, but you can insert a document
into excel under the 'Insert' 'Object' menu.


All times are GMT +1. The time now is 09:04 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
ExcelBanter.com