#1
|
|||
|
|||
Merge fields in Word and source data from Excel
Hi everyone, I was wondering if someone knew how to do the following- I have a serious of data from an excel worksheet, in columns A & B as follows-: Note: Column A is static data, Column B is the variable... DATE 12 March 2014 SALUTATIONM Mr I want to be able to insert merge fields from column A, throughout certain places of a word document? For instance every time the merge field says DATE in the word document, the 12 March 2014 would appear. Anywhere SALUTATIONM merge fieldappears, Mr would appear. I have something like over 100 different column codes, however I've kept this simple for this specific example anyway. Any help or guidance would be greatly appreciated. |
#2
|
||||
|
||||
You can put your mergefields wherever you like in the mailmerge main document, multiple times, if you wish. Instead of having DATE and SALUTAIONM in the document, though, you'd insert mergefields at those locations, referencing your column headings in Excel.
FWIW, you post suggests you need to spend a bit more time learning how mailmerge works. See: http://office.microsoft.com/en-us/wo...001034920.aspx http://support.microsoft.com/kb/294683 http://office.microsoft.com/en-us/wo...101857701.aspx http://word.mvps.org/FAQs/MailMerge/...AMailMerge.htm
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
You need Date and Salutation to be column headings in the first row in your Excel spreadsheet. The next row would have March 12, 2014 and Mr. Following rows would have the data for other records.
First row = header - corresponds to your merge field names Following rows = data See Mail Merge |
#4
|
|||
|
|||
Thanks guys for your help. I managed to get it working with your guidance..
Thanks again |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Enable Mail Merge Data Source always in same folder | alleycat1998 | Mail Merge | 1 | 04-10-2013 03:02 AM |
How to dynamically link imbedded Excel chart with source data from Word | TBoz | Excel | 1 | 07-06-2012 05:53 PM |
How can I revise Excel data source in merge? | navysalad | Mail Merge | 6 | 01-07-2012 06:50 PM |
Mail Merge data source on network drive | Brandi | Mail Merge | 0 | 06-13-2010 11:26 AM |
How do I set up the fields in mail merge word 07 from my data base | mbcrabber | Mail Merge | 4 | 06-06-2010 01:25 PM |