Mail Merge with Macros

[Guest]

Is it possible to do a mail merge for Address Labels using Macros in Excell.

I am creating new worksheets and having people set it up using Word.
However they are selecting the wrong new workbooks from time to time and
sending information out to the wrong individuals.

I was informed that you can do this antomatically, but I have never seen it!

Thanks for the Consulting

Granny

 

[Guest]

That would be better asked in a word group since it sounds like the work (and
the macro) would be in word.
maybe look here http://word.mvps.org/FAQs/MailMerge/index.htm

 

[Guest]

Tom;
Thank You, I will check it out!
Granny

That would be better asked in a word group since it sounds like the work (and
the macro) would be in word.
maybe look here http://word.mvps.org/FAQs/MailMerge/index.htm

 

[Guest]

If you don't find what you need. I am working on same problem and almost
there. Create a mocro in word then you can run it from Excel. Got this to
work fine trouble with word macro tho.