 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / December 2004Merge With Excel
I am creating a form letter in Word, with an Excel file as the source. I am able to merge the file fine, except there is once cell that is not in the Merge Data Range, that I want in each document. How do you insert a single cell from an Excel file into a word document? NOTE: The cell I want to add in is a formula, which is why i simply can't type it in the document. Hope this is clear. Thank you. The thing to do is to include the column in which that cell is located in the datarange. Is there any reason that you cannot do that?  SignaturePlease respond to the Newsgroup for the benefit of others who may be interested. Questions sent directly to me will only be answered on a paid consulting basis. Hope this helps, Doug Robbins - Word MVP >I am creating a form letter in Word, with an Excel file as the source. I >am [quoted text clipped - 5 lines] > type it in the document. > Hope this is clear. Thank you. Well, 2 things: 1)If I have say 10 records, and include this data as its own column in the range, it is only 1 or 2 records long, it will insert blank at the 3rd record (correct? I would need it to repeat that cell at each record?) Also, the records may change fairly often, and already consist of many columns. What i am looking to do is: Header row and data are rows C through Z. There is data in Cell A1 and B1 that I would like on each letter. So, I would like to Merge rows c - z into the word Doc, and insert(?) Cells A1 and B1. > The thing to do is to include the column in which that cell is located in > the datarange. Is there any reason that you cannot do that? [quoted text clipped - 8 lines] > > type it in the document. > > Hope this is clear. Thank you. You need to repeat that data for each record. A simple copy past (click-drag) operation in Excel. SignaturePlease respond to the Newsgroup for the benefit of others who may be interested. Questions sent directly to me will only be answered on a paid consulting basis. Hope this helps, Doug Robbins - Word MVP > Well, 2 things: 1)If I have say 10 records, and include this data as its > own [quoted text clipped - 25 lines] >> > type it in the document. >> > Hope this is clear. Thank you. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.