how do i use word to print multiple records

S

Sam Jet

I have a Excel table which looks like something below
Its sorted on DOC_N

Cust_Name DOC_NO Book_Titl
George Shaw 123456 Teach me Exce
Rudy Miller 250024 The ideal Teache
Rudy Miller 250024 The Red Hamle

I need to print letters such that next page / letter should only com
when the DOC_NO changes

Desired output

(Letter1
Dear George Shaw

Ref : Document 12345

You have not returned the below books
Book_Titl
Teach me Exce

------------
(Letter2
Dear Rudy Miller

Ref : Document 25002

You have not returned the below books
Book_Titl
The ideal Teache
The Red Hamle
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging to Word - How & Where do I place criteria? 3
Word 2003 - How do I stop track changes from saving on print? 0
How do I get records to print on the proper document? 6
How do I get Word to print linked pictures? 5
How do I print a page from IE to a pdf or word document? 2
How do I use Word Art -pasted screen print 1
How do I get WORD to print a red page with white font 4
How do I get an e-mail address to print in a Word Document 1

Top