![how to do a mail merge in word 2002 how to do a mail merge in word 2002](https://flylib.com/books/1/388/1/html/2/files/12inf13.jpg)
- #How to do a mail merge in word 2002 update#
- #How to do a mail merge in word 2002 code#
- #How to do a mail merge in word 2002 series#
Now we choose the second ingredient in our Mail Merge recipe, the list of recipients. We already have our document open, so all we need to do is click Next: Select recipients. Click the button at the bottom right-hand corner: Next: Starting document. So, all you need to do is go to the next step. It defaults to creating a letter, which is exactly what we want. The Mail Merge Wizard has just six steps, the first of which is the easiest. A menu of possibilities appears, and easiest choice is to go to the bottom and employ the Step-by-Step Mail Merge Wizard. In that tab, click the button: Start Mail Merge. In Microsoft Word, if you want to start a Mail Merge, you will of course go to the Mailings tab. But such simple-minded gimmicks impress nobody, and for this example we’ll keep things simple.) 3. For example, we can add the line, “I hope things are going well in X,” Where X would be substituted by the recipient’s city. (We could also put some information from the recipient list into the body of the letter. There is a placeholder for the Inside Address and another for the salutation line.
#How to do a mail merge in word 2002 update#
The date near the top is set to update every time we create a new batch of letters, which is a good idea for a Mail Merge letter. I have prepared a simple letter with the file name Mail_Merge_Letter.docx. You can use almost any document in Mail Merge.
#How to do a mail merge in word 2002 code#
(This problem will occur even if you use the special Zip Code format of Excel.) Close the Excel file and proceed to the next step. 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.
![how to do a mail merge in word 2002 how to do a mail merge in word 2002](https://stevechasedocs.files.wordpress.com/2013/08/example-of-data-list-excel1.jpg)
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.
#How to do a mail merge in word 2002 series#
The process can seem daunting to a beginner, but if you break it down into a series of steps, is very easy to manage. If you want to change the filename or where the files are saved, change the setting for the BaseName variable in the macro.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. The last section in the document is left in the original file (the one you are processing). Actually, the macro creates one "Ltr" file less than the number of sections in the document. When the macro is run, it creates a series of files named Ltr001 through Ltrxxx, where xxx is the number of sections in the original document. Selection.Delete Unit:=wdCharacter, Count:=1 Selection.MoveLeft Unit:=wdCharacter, Count:=1 If numlets > 1 Then numlets = numlets - 1ĭocName = BaseName & Right("000" & LTrim(Str(Counter)), 3) Numlets = Selection.Information(wdActiveEndSectionNumber) Each section of the document (there is one section per data source record) is pulled out and saved in its own document file. The following is a macro that will "pull apart" a document created by the mail merge feature. Fortunately you can create a macro to take care of the task for you. Unfortunately, Word does not provide a way to do this. There may be times, however, when you need to create an individual document for each of the data source records. (Each record in the data source would create an individual e-mail message.) Depending on your Word version and installation, you may also be able to merge to a series of e-mail messages. The standard mail merge capabilities of Word allow you to merge directly to a printer or to a new document.