ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can you highlight a record and it print a single report? (https://www.excelbanter.com/excel-discussion-misc-queries/102852-can-you-highlight-record-print-single-report.html)

MarkC

Can you highlight a record and it print a single report?
 
I have a table in Excel. I would like to be able to highlight a record and
then have it print out to a report? Or to be able to choose several records
and have them printout in a report format. How can this be done? Thanks. MJ

Dave Peterson

Can you highlight a record and it print a single report?
 
Maybe using MSWord's MailMerge????

You may want to read some tips for mailmerge.
http://www.mvps.org/dmcritchie/excel/mailmerg.htm
http://www.mvps.org/word/FAQs/MailMerge

The first is from David McRitchie and the second is by Beth Melton and Dave
Rado.



MarkC wrote:

I have a table in Excel. I would like to be able to highlight a record and
then have it print out to a report? Or to be able to choose several records
and have them printout in a report format. How can this be done? Thanks. MJ


--

Dave Peterson

MarkC

Can you highlight a record and it print a single report?
 
Duh... Sometimes the obvious. Thank you very much. It is exactly what I
needed. Why I didn't think of it... It is working great. Thanks again. Take
care.
MJ

"Dave Peterson" wrote:

Maybe using MSWord's MailMerge????

You may want to read some tips for mailmerge.
http://www.mvps.org/dmcritchie/excel/mailmerg.htm
http://www.mvps.org/word/FAQs/MailMerge

The first is from David McRitchie and the second is by Beth Melton and Dave
Rado.



MarkC wrote:

I have a table in Excel. I would like to be able to highlight a record and
then have it print out to a report? Or to be able to choose several records
and have them printout in a report format. How can this be done? Thanks. MJ


--

Dave Peterson



All times are GMT +1. The time now is 01:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com