Post # 1
I’ve been working on & off on my guest list spread sheet. I have everyone’s names & addresses, but I’ve been trying to arrange it so it can be conveniently mail merged. Right now my columns are First Name, Last Name, Significant Other, Kids 14+, after that it’s the address, phone, etc. What’s a good way to organize the list so I can mail merge for invite addressing?
Post # 3
- Wedding: June 2010 - Ceremony - First United Methodist Church; Reception - My parents' house!
Try the layout that they use on http://docs.google/wedding
That spreadsheet was perfect, and super easy to edit, etc.
Post # 4
We had a column for “Name on Outside of Envelope” where we wrote out “Mr. Bob Smith and Family” or whatever…that was most helpful for us in organizing the names for mail merge!
Post # 5
I just looked up what Mail Merge is… I never knew Microsoft Word could do that!
It looks like you should make sure the address is split up into street address, city, state, and zip in separate columns for easy merging.
By the way, I found a tutorial on it here (click on Label Mail Merge 2003):