Newbie question 
Author Message
 Newbie question

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



Sat, 31 Jul 2004 00:04:50 GMT  
 Newbie question
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



Sat, 31 Jul 2004 05:26:58 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Newbie question: Session_OnEnd question

2. Resizing forms question (newbie question)

3. Access97 VBA newbie question

4. Newbie Question: Understanding Syntax

5. Newbie question:

6. Newbie Questions About DAO Queries to SQL Server

7. Brand newbie questions

8. Newbie question

9. Newbie question: open file

10. vba Newbie Question

11. Newbie Question: Getting the Values from Calculated controls into a table

12. Newbie question for calling functions

 

 
Powered by phpBB® Forum Software