Creating Mailing List In Excel
How to include w / contact names different, but even the addresses in an Excel spreadsheet?
I can create a list of contacts for a client in an Excel client to become a letter for a mass mailing. I learned to use Excel and work my way through a process of combination correspondence, but I wonder how to handle some of your contacts who live in the same direction but have different names: that is to say John Smith and Jane Doe (who shared a home and receive one letter.) Currently the Excel spreadsheet has a column for the name, address, city, state and code Zip. How can I add these additional names while ensuring that receives only a letter sent to the address that you share?
Add a column to call recipients and take the person to receive the letter. Use this column in MailMerge Name of place cells. I also welcome be included in your case, sir, Miss, etc. In your MailMerge include only cells of recipients that are not empty. An easy way to get the names together is to use = concatenate (Name, "", name) copy in the dropdown menu, then delete the formula of these cells are not necessary.