Reply
 
Thread Tools Display Modes
  #1   Report Post  
Sam Jet Sam Jet is offline
Junior Member
 
Posts: 1
Default how do i use word to print multiple records

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

Cust_Name DOC_NO Book_Title
George Shaw 123456 Teach me Excel
Rudy Miller 250024 The ideal Teacher
Rudy Miller 250024 The Red Hamlet

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

Desired output:


(Letter1)
Dear George Shaw,

Ref : Document 123456

You have not returned the below books :
Book_Title
Teach me Excel

-------------
(Letter2)
Dear Rudy Miller,

Ref : Document 250024

You have not returned the below books :
Book_Title
The ideal Teacher
The Red Hamlet


------

It would be great if some one can help...

Last edited by Sam Jet : September 25th 12 at 02:18 AM Reason: missed some info
Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
merge multiple records for multiple clients? jewell Mailmerge 5 July 10th 08 06:02 PM
Multiple Records / Rows from Excel to Word kolwinsm Mailmerge 1 August 22nd 07 08:34 PM
How do I get multiple pages when merging records in word? aaron Microsoft Word Help 1 July 27th 06 05:32 PM
print multiple records merge Missy Mailmerge 1 March 14th 06 07:17 PM
Email Print Merge with multiple records in the document B Ehart Mailmerge 2 December 21st 05 12:36 AM


All times are GMT +1. The time now is 03:31 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"