Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Printing / January 2006

Tip: Looking for answers? Try searching our database.

Printing columns to an envelope in Excel 2003

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Kara - 19 Jan 2006 22:01 GMT
A customer of mine has an Excel spreadsheet with 300 names and addresses.  
The addresses are formatted in 5 columns: name, street address, city, state,
and zip code.  She would like to print one column to an envelope.  In Excel
you can change select the column for the print area, change the page setup to
an envelope, center the information on the envelope, etc.  

How can I make the information in each column show as if they were in rows
when it is printed in Excel?  

She could use mail merge but that is quite the process to print one
envelope.  I guess she could also copy and paste and create one envelope in
Word.  It would be easiest if she could quickly change the page set-up and
print within Excel.

Thanks for your help!
David McRitchie - 19 Jan 2006 22:42 GMT
Hi Kara,
Mail Merge is what you want it will print all of the labels not just one.
Take another look.

http://www.mvps.org/dmcritchie/excel/mailmerg.htm
this page is geared to printing labels,  but envelopes are the same
you may have to feed them one at a time depending on your printer.

---
HTH,
David McRitchie, Microsoft MVP - Excel    [site changed  Nov. 2001]
My Excel Pages:  http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:        http://www.mvps.org/dmcritchie/excel/search.htm

> A customer of mine has an Excel spreadsheet with 300 names and addresses.
> The addresses are formatted in 5 columns: name, street address, city, state,
[quoted text clipped - 11 lines]
>
> Thanks for your help!
Gord Dibben - 19 Jan 2006 23:34 GMT
Kara

If she wants to print just one envelope..........

Copy the five cells from a row and insert a new worksheet then Paste Special(at
E3)>Transpose>OK

Now do your page setup for just that one address on an envelope.

If more than one, suggest she go with the mailmerge.

Gord Dibben  MS Excel MVP

>A customer of mine has an Excel spreadsheet with 300 names and addresses.  
>The addresses are formatted in 5 columns: name, street address, city, state,
[quoted text clipped - 11 lines]
>
>Thanks for your help!

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.