ZIP codes will be truncated off by Excel when it exports it to Microsoft Word. Otherwise the leading zeros that are used in certain U.S. Unfortunately, this is mandatory: You must set the Postal Code column as text. If you look carefully, you will note that the Postal Code column is set as text, which is why the ZIP codes appear on the left side of the cells. I have prepared a very simple table of names and addresses in the file Mail_Merge_Recipients.xlsx. It will save some time later if you use a few standard labels in the column headers, such as, Last Name, Street, City, etc.
There must be only one row of column headers at the top of the table, and each column headers should be unique. The list of recipients is simply a table of names and addresses.
In this example, we will use an Excel spreadsheet and a simple letter that has already been created in Word. This list could be a table in Microsoft Word, but most often it is a worksheet in Excel. The first file is a letter, which is a basic word document. The Mail Merge process basically involves taking two files and merging them together. The process can seem daunting to a beginner, but if you break it down into a series of steps, is very easy to manage.
The Mail Merge feature of Microsoft Word is a great way to produce a large number of personalized letters or labels in a short amount of time.
0 kommentar(er)
