Yet visibly see that is messed up, in the formatting perhaps. I am assuming that there is something that I cannot I have rebuilt both the mail merge template and the excel spreadsheet, but nothing helps. What I see in Word after the merge, does not match what is in the Excel spreadsheet. On the Excel spreadsheet, each addressee is listed only once with their specific The same addressee and contact information is repeated on each label on a page, while the donation amounts are for other donors on my list. Each label should have a different addressee along with their contact information and donation amounts to our company. I have 3 labels per page on my label template. I am performing a Mail Merge from Excel to Word. "NorthernAssistant" wrote in message news:*** Email address is removed for privacy ***. You need a «Next Record» field before the first merge field in the second and third labels in the mail merge main document. Graham Mayor (Microsoft Word MVP 2002-2019) For more Word tips and downloads visit my web site See that is messed up, in the formatting perhaps. On the Excel spreadsheet, each addressee is listed only once with their specific information on the same row. I am assuming that there is something that I cannot yet visibly On the Excel spreadsheet, each addressee is listed only once with their specific information
When I complete the merge, the sameĪddressee and contact information is repeated on each label on a page, while the donation amounts are for other donors on my list.
WARNING: In order for the merge to work correctly, the field names of your Excel table must begin in the top left corner of your worksheet, at cell A1. For more information about creating Excel tables, refer to Creating Tables.
I am performing a Mail Merge from Excel to Word. For more information about Word's Mail Merge process, refer to Mail Merge: An Overview. When merging, select send e-mail messages. wrote in message news:*** Email address is removed for privacy ***. Create the data source, include a field email address fill in the email address, one in a cell, one below the other 3. You need to set the merge document type to labels and then you can propagate the information from the first label to the rest - assuming you are using a table!
0 kommentar(er)
