Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I maintain a club membership list of about 400 in Excel. With help
from this group (thanks, Ron!) I have been able to launch Outlook to automate e-mail to the membership. I'd like to do the same kind of thing with Word/mailMerge to generate snail-mail labels. Now, I use VBA in Excel to do the more tedious aspects of formatting the addresses, then leave Excel, open a previously created label layout document with Word, and thus create a file with the labels. I would like a one step process, i.e., just select "make labels" from a menu choice in Excel. I expect it's a lot the same as launching Outlook from VBA, but I don't know the details. Can anyone give me some hints? TIA Ed |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Printing XLS source on nonlabel mailmerge header DOC | Excel Discussion (Misc queries) | |||
Label Matrix - importing and printing excel files | Excel Discussion (Misc queries) | |||
How can I do a mail merge for printing label from an excel spread | Excel Discussion (Misc queries) | |||
Can I put 2+ rows from excel on a single label using mailmerge | Excel Discussion (Misc queries) | |||
How do I tell Excel that I'm printing a 1" high label | Setting up and Configuration of Excel |