Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-07-2020, 01:55 AM
prasademany prasademany is offline Mail Merge with multiple records Windows 10 Mail Merge with multiple records Office 2013
Novice
Mail Merge with multiple records
 
Join Date: Apr 2020
Posts: 3
prasademany is on a distinguished road
Default 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.
Attached Files
File Type: xlsx Trail Data.xlsx (11.6 KB, 13 views)
File Type: docx L_sheet.docx (14.0 KB, 11 views)
Reply With Quote
  #2  
Old 04-07-2020, 02:18 AM
macropod's Avatar
macropod macropod is offline Mail Merge with multiple records Windows 7 64bit Mail Merge with multiple records Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,224
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

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]
Reply With Quote
  #3  
Old 04-08-2020, 04:32 PM
prasademany prasademany is offline Mail Merge with multiple records Windows 10 Mail Merge with multiple records Office 2013
Novice
Mail Merge with multiple records
 
Join Date: Apr 2020
Posts: 3
prasademany is on a distinguished road
Default

If this is not possible with mail merge.. please suggest any other way to get printout as shown in word format.
Reply With Quote
  #4  
Old 04-08-2020, 08:41 PM
macropod's Avatar
macropod macropod is offline Mail Merge with multiple records Windows 7 64bit Mail Merge with multiple records Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,224
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

I have already told you how to do it with mailmerge.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 04-15-2020, 05:32 AM
Marcia's Avatar
Marcia Marcia is offline Mail Merge with multiple records Windows 7 32bit Mail Merge with multiple records Office 2013
Expert
 
Join Date: May 2018
Location: Philippines
Posts: 425
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

Quote:
Originally Posted by macropod View Post
Simply insert the required mergefield in each cell, plus «Next Record» fields in all 'Sl. No' cells but the first.
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.
Reply With Quote
  #6  
Old 04-15-2020, 06:10 AM
macropod's Avatar
macropod macropod is offline Mail Merge with multiple records Windows 7 64bit Mail Merge with multiple records Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,224
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

That's not what I see. See attached mailmerge main document & output document.
Attached Files
File Type: docx Output.docx (32.4 KB, 21 views)
File Type: docx L_sheet.docx (18.5 KB, 13 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #7  
Old 04-15-2020, 07:05 AM
Marcia's Avatar
Marcia Marcia is offline Mail Merge with multiple records Windows 7 32bit Mail Merge with multiple records Office 2013
Expert
 
Join Date: May 2018
Location: Philippines
Posts: 425
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

Paul, thank you. I missed the very important part of your first reply to the OP, "but the first."
Reply With Quote
  #8  
Old 05-08-2020, 05:55 AM
prasademany prasademany is offline Mail Merge with multiple records Windows 10 Mail Merge with multiple records Office 2013
Novice
Mail Merge with multiple records
 
Join Date: Apr 2020
Posts: 3
prasademany is on a distinguished road
Default Mail Merge with multiple records - Need Help

Quote:
Originally Posted by macropod View Post
I have already told you how to do it with mailmerge.
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
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge with multiple records Mail Merge Grouping Multiple Records into 1 Output DeniseStafiej Mail Merge 1 08-03-2018 03:41 PM
Mail Merge with multiple records 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
Mail Merge with multiple records How to merge multiple records into one and update the cells mag Excel 1 10-30-2012 01:11 AM
Mail Merge with multiple records Multiple mail merge records on the same page allenglishboy Mail Merge 3 07-18-2012 06:22 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:02 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft