Printing address labels, and more complicated stuff

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

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

On Fri, 08 Jun 2007 09:11:13 -0400, Fred Holmes <fsh RemoveThis @his.com> wrote:

>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