Software

Ask something
Discussion Locked

Creating Labels from Multiple Addresses

0 helpful
3 replies

by borginva

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have in Excel a bunch of contacts and mailing addresses. We need to do labels to mail out. How can I export this data from Excel of 100+ addresses into Word 2k/2k3 so each labels has a different address and all we have to do is print and stick?
Thanks.

3 replies

by dklippert

There is no need to export the data.
In Word, go to Tools>Letters and Mailings and choose Mail Merge.
In the task pane choose Labels. Click Next at the bottom of the pane.
Click label size and select the product number for your labels.
Click next at the bottom of the pane.
"Use an existing list" should be selected.
Click Browse. Navigate to the location of your Excel file.
Change "Files of type" to Excel files. Click open.
I prefer to use DDE.
Select your data range.
Click Next at bottom of pane.
Click Address block.
Click Update labels.
Click next at the bottom of the pane.
Hopefully your Excel data is separated into Name, Address, City, State, Postal code.

This discussion is closed to new replies.