Mail Merge in Word 2002

[AlanN]

I have a database of addresses in Excel 2002 and I want to import each record and print a full page of labels (30 with my label type), then continue doing the same for the etire Excel DB. Can anyone either tell me how to do it or point me to a good web source that specifically lays out the steps required?

TIA, AlanN

 

[Valary Oleinik]

I have a database of addresses in Excel 2002 and I want to import each
record and print a full page of labels (30 with my label type), then
continue doing the same for the etire Excel DB. Can anyone either tell
me how to do it or point me to a good web source that specifically lays
out the steps required?

TIA, AlanN
--

Follow the prompts through the Mail Merge Wizard (under Tools, Letters
& Mailings). This will ask you for items such as the type of label,
where the records are you want to use (in your case the Excel file),
etc.

When you get to Step 4 of the process, Word will fill in Next Record
fields in all of the labels except the first one. This is the point at
which you select the fields you want to show up on the labels based on
your columns in the Excel file. You can click on the More Items choice
in the wizard task pane to bring up the list of fields to choose from.
Set up the first label with the fields you want and then copy the
fields to the other labels on the page.

The trick is to delete all of the Next Record fields except the one in
the last label on the page. This tells Word to keep using the same
record until it hits the end of the page and then to advance to the
next record.

Valary

 

[AlanN]

Thanks for the help, Valary!!
Regards, Alan

"AlanN" <[email protected]> wrote in message

Follow the prompts through the Mail Merge Wizard (under Tools, Letters
& Mailings). This will ask you for items such as the type of label,
where the records are you want to use (in your case the Excel file),
etc.

When you get to Step 4 of the process, Word will fill in Next Record
fields in all of the labels except the first one. This is the point at
which you select the fields you want to show up on the labels based on
your columns in the Excel file. You can click on the More Items choice
in the wizard task pane to bring up the list of fields to choose from.
Set up the first label with the fields you want and then copy the
fields to the other labels on the page.

The trick is to delete all of the Next Record fields except the one in
the last label on the page. This tells Word to keep using the same
record until it hits the end of the page and then to advance to the
next record.

Valary