If I am doing a word document, which I am wanting to merge in other information ie doing personalised letters, should the data to be imported be in an excel spreadsheet format or a word document table?
No one in the office to help me with this, for some reason everyone is off today :)
|
I've had most success with this when the data is in Excel, but I'm sure Word can cope with other means.
|
I prefer to use excel to merge, but thats only because I think its easier to keep data updated and sorted in excel rather than Word.
|
OK thanks guys, I will do it in excel.
Another item scored off today's to-do list!
|
It's a few years since I've done that; in Word 2003 IIRC, but I used a Word table. A quick Google suggests you can use all sorts of formats.
office.microsoft.com/en-us/word-help/word-mail-merge-a-walk-through-the-process-HA001034920.aspx?CTT=5&origin=HA001109550
Presumably there's info on the MS web site somewhere on newer versions.
|