Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 18
Default Addressing envelopes

I normally send out about 100-200 envelopes per month and have been
buying labels for them.
Would anyone know of a way to use Microsoft Word or Excel to print the
addresses from an Excel workbook directly to the envelopes thus saving
the cost of the labels?

I would like to load the printer with the envelopes and hit a key and
have them print. Is this even possible?

Thanks in advance
xnman

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Addressing envelopes

Look at the mail merge feature in Word. It can do this using excel as a
source for the addresses. Actually, there is an envelopes and labels feature
just below the mail merge which is actually used for this. Both are under
the tools menu. There is a wizard that will walk you through the process.

--
Regards,
Tom Ogilvy

"xnman" wrote in message
...
I normally send out about 100-200 envelopes per month and have been
buying labels for them.
Would anyone know of a way to use Microsoft Word or Excel to print the
addresses from an Excel workbook directly to the envelopes thus saving
the cost of the labels?

I would like to load the printer with the envelopes and hit a key and
have them print. Is this even possible?

Thanks in advance
xnman



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 18
Default Addressing envelopes

Thanks Tom. You gotta love the forums. Great for getting help and ideas.

Tom Ogilvy wrote:
Look at the mail merge feature in Word. It can do this using excel as a
source for the addresses. Actually, there is an envelopes and labels feature
just below the mail merge which is actually used for this. Both are under
the tools menu. There is a wizard that will walk you through the process.


Reply
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
how do i print from excel to envelopes gus Excel Discussion (Misc queries) 2 March 29th 10 08:46 PM
printing envelopes from excell Rick Excel Discussion (Misc queries) 1 December 4th 07 04:31 AM
how to make envelopes with christmas design? Technopam Excel Discussion (Misc queries) 1 November 7th 07 12:57 PM
Can Excel Adress Envelopes? Donald Excel Worksheet Functions 1 September 20th 06 07:52 PM
Printing Envelopes xnman Excel Programming 2 October 7th 03 02:41 AM


All times are GMT +1. The time now is 09:25 PM.

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

About Us

"It's about Microsoft Excel"