Mail Merge & Printing on Envelopes

Just a suggestion, since I live in Excel for work, but you can create a column in Excel and call it Envelope Name or something like that, and just make sure for every record you have it written out exactly how you want it to appear. Then when you set up the merge, just select that field instead of messing with First Name/Last Name.

Oh so like in the same column I would put "John Doe" or "John Doe & Jane Smith" or "John & Jane Smith" instead of having seperate columns for first name, last name, spouse first name, spouse last name??

View Quoted Comment

Yep, then just use that one. My guest list spreadsheet has all the variations in columns. First Name/Last Name just so we can find people, a more casual "John and Jane Smith" that we used for STDs, and then "Mr and Mrs John Smith" that we'll use for invites.

I tried and failed with mail merge. Lol but I made custom sheet size as close to my envelope size as it woul let me and just had a bunch of sheets with the envelope layouts lol
Much faster than putzing around with MM when I'm terrible at excel!

I wish I was tech savvy enough with Word to do that lol.