#1
|
|||
|
|||
Mail Merge with multiple records
Hi all, I have data in excel file (Attached). I want to mail merge 2 records in one page as shown in word file attached. Column A in excel file represents page no. and Sl.No (1-4) represents Associate Name should be printed serially as shown in word file. Is it possible through mail merge. If possible please help me. |
#2
|
||||
|
||||
Simply insert the required mergefield in each cell, plus «Next Record» fields in all 'Sl. No' cells but the first.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
If this is not possible with mail merge.. please suggest any other way to get printout as shown in word format.
|
#4
|
||||
|
||||
I have already told you how to do it with mailmerge.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
||||
|
||||
Hi. I tried the <<Next Record>> in my mail merge document but the addressee (merge field) on the second record of the first page is repeated on the first record of the second page.
|
#6
|
||||
|
||||
That's not what I see. See attached mailmerge main document & output document.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#7
|
||||
|
||||
Paul, thank you. I missed the very important part of your first reply to the OP, "but the first."
|
#8
|
|||
|
|||
Mail Merge with multiple records - Need Help
Hi,
I have seen Directory in Mail Merge option, can we get exact report as per requirement. Please try in that toggle coding, need to be filled in table and other fields should be placed with insert field option. Thanks and Regards, Prasad Emany |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail Merge Grouping Multiple Records into 1 Output | DeniseStafiej | Mail Merge | 1 | 08-03-2018 03:41 PM |
How do I mail merge records into table columns with more than one merge field? | tech123 | Mail Merge | 1 | 04-26-2017 07:13 PM |
Multiple Records Mail Merge using Email | Skybluekid | Mail Merge | 1 | 03-28-2016 02:33 PM |
How to merge multiple records into one and update the cells | mag | Excel | 1 | 10-30-2012 01:11 AM |
Multiple mail merge records on the same page | allenglishboy | Mail Merge | 3 | 07-18-2012 06:22 AM |