General discussion

Locked

Creating Labels from Multiple Addresses

By BorgInva ·
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.

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by DKlippert In reply to Creating Labels from Mult ...

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.

Collapse -

by BorgInva In reply to

Bless you!

Collapse -

by BorgInva In reply to Creating Labels from Mult ...

This question was closed by the author

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums