How should I format addresses in a spreadsheet with Excel or Google Sheets when I’m doing a Mailer?

Sometimes you have two people at the same address, like two partners with different last names living together. We recommend adding a name 2 field for clarity. This list has an optional salutation field as well. This is usually used on inner materials, like a letter. Example: You want the envelope address to read “John Smith and Jane Doe” and the greeting inside the letter to say something like “Dear John and Jane,”.