Hi Tom,
From the sound of it you want Word mailmerge. With this you can create your labels in Word and merge them with an datasource (your addresses) in another application (like Excel)
See:
"How to create a Mailmerge"
http://www.mvps.org/word/FAQs/MailMerge/CreateAMailMerge.htm
Hope this helps,
regards,
Astrid
So that all can benefit from the discussion, please post all follow-ups to the newsgroup.
Visit the MVP Word FAQ site at http://www.mvps.org/word/
Quote:
> Hi all,
> I have an excel worksheet with names and addresses.
> I have a word document with a text box with border
> and to and from addresses and a little notation text in the corner.
> Currently I am cutting and pasting between the apps.
> I would like to automate the creation and printing of this mailing label
> from within excel.
> I would like some advice. I do not know word very well. Would templates be
> the way?
> search and replace text?
> Any help would be appreciated!
> Thanks
> Tom