LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 34
Default MailMerge Label printing from Excel

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Printing XLS source on nonlabel mailmerge header DOC [email protected] Excel Discussion (Misc queries) 0 September 2nd 09 10:14 PM
Label Matrix - importing and printing excel files Tina Excel Discussion (Misc queries) 1 April 14th 09 08:55 PM
How can I do a mail merge for printing label from an excel spread danish firemen Excel Discussion (Misc queries) 1 December 20th 05 02:53 AM
Can I put 2+ rows from excel on a single label using mailmerge Frenchy Excel Discussion (Misc queries) 1 October 5th 05 06:01 PM
How do I tell Excel that I'm printing a 1" high label Pdude Setting up and Configuration of Excel 1 June 1st 05 05:06 AM


All times are GMT +1. The time now is 02:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"