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 / June 2007

Tip: Looking for answers? Try searching our database.

Printing address labels, and more complicated stuff

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Fred Holmes - 08 Jun 2007 14:11 GMT
I believe I've read/heard somewhere that one can keep a table of names
and addresses in Excel and print address labels.  Where are the
instructions written up?

I'm interested in a more general situation.  I have a table [database]
in an Excel worksheet.  I'd like to be able to print one record (row)
of the table, with customized formatting, so that it is all visible on
one "portrait" sheet of paper.  Or even several records per page, or
whatever.  Being able to print the records one after the other,
vertically, on a sheet of paper would be sufficient.

Simplistically, the row would be "wrapped" into several lines, but I'd
like to do something more customized than simple wrapping.

Basically I'd like to write a procedure that would take the data in
any explicit cell in the workbook (across spreadsheets) and place it
in an explicit location on the printed page.

Many thanks,

Fred Holmes
Gord Dibben - 08 Jun 2007 20:57 GMT
Fred

For help on Word mail merge using Excel or Access as the data source.

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

http://www.mvps.org/word/FAQs/MailMerge/CreateAMailMerge.htm

http://www.mvps.org/word/FAQs/MailMerge/CreateADataSource.htm

As far as the rest of it goes you may get away with Data>Filter>Autofilter to
select records to print.

The wrapping and formatting part can be done manually.

Moving data from one place to another usually involves some VBA code.

Try turning on the macro recorder whilst you copy and paste the data to
wherever.

Gord Dibben  MS Excel MVP

>I believe I've read/heard somewhere that one can keep a table of names
>and addresses in Excel and print address labels.  Where are the
[quoted text clipped - 17 lines]
>
>Fred Holmes

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.