PDA

View Full Version : Mail Merge Personalize Letter Bodies From Excel Column



SamT
02-19-2014, 07:10 AM
First I volunteered to be on the Board of Directors of a Volunteer Fire Department.

Then I volunteered to update the Members list.

And the By-Laws.

And create an Accounting system.

Gotter done.

Now I am writing the Annual Notice. They will be commercially printed and the printer needs the Merge document as one file. no problem.

The problem is that I am running out of time. :banghead:

I've got the notice written and have the addresses placed on Page 1, but I need to add a field in the body of each notice that pulls individual data for each addressee from the Excel table that holds their names and addresses.

The Table headers are Number_ Properties, Name, Address, City, etc.

In the letter body, I need to say
Blah blah blah [Number_Properties] blah blah blah.

If you can give me a quick pointer, I can figure it out

macropod
02-20-2014, 01:34 AM
See: http://office.microsoft.com/en-us/word-help/word-mail-merge-a-walk-through-the-process-HA001034920.aspx

westconn1
02-20-2014, 03:54 AM
The Table headers are Number_ Properties, Name, Address, City, etc.
add another column to table, put new header as mergefield in body

SamT
02-20-2014, 06:03 AM
Thanks guys. with that, I'm off to the mines.

macropod
02-20-2014, 02:18 PM
add another column to table, put new header as mergefield in body
What would that achieve? The only variable (Number_Properties) is already in the table. All that's needed is for the «Number_Properties» mergefield to be added to the document body.