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!