Post # 1
I would like to do a mail merge for my invite envelopes and understand that I’m supposed to create a first name column and last name column… as well as colums for address, state, zip…. But what about the titles (Mrs., Dr., Rev., etc)? Also, what if I need to do “The ___ Family”?
Can someone please explain how to set up the excel file for that? Your help is much appreciated! 🙂
Post # 3
- Wedding: July 2007 - Rosary Chapel & Monterey Marriott, Monterey, CA
It’s easiest if you do a “NAME” column for mail merge for these instances. Then, you’ll enter the FULL name as you wish it to be printed, be it “The Jones Family” or “Joan and Robert Thomas” or “Mr. and Mrs. Jacobs.” Does that make sense?
Then use the following columns: Address 1, Address 2, City, State, Zipcode.
Then, when you do the merge, you can arrange it like this:
<<Address 1>>, <Address 2>> (or however you want it)
<<City>>, <<State>> <<ZIP>>
Post # 4
I would just do one name column, which would say, “Dr and Mrs Smith” or “The Smith Family.” Then merge it in… That way you don’t have to worry about the mail merge doing it correctly.