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