Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-23-2021, 10:06 AM
BNDCK BNDCK is offline Multiple Records in Mail Merge Document in MS Word Windows 10 Multiple Records in Mail Merge Document in MS Word Office 2010
Novice
Multiple Records in Mail Merge Document in MS Word
 
Join Date: Jul 2021
Posts: 3
BNDCK is on a distinguished road
Default Multiple Records in Mail Merge Document in MS Word

I have many Invoices for a single customer to sent for reminding due payments. I have perfectly managed to write Directory solution(data is stored in flat excel sheet ) and the get the desired output letter to be sent each customer.

My Code is here

{ IF { MERGESEQ } = "1"
Date : {Date \@" dd-MM-yyyy" \* MERGEFORMAT }
"Dear { MERGEFIELD Name },

I have herewith attached all Invoices and relevant dates which are pending. Please made arrangements as soon.


Kind Regards,
Paul Samson - Recovery Manager" "" }

{ SET Place1 { MERGEFIELD Customer No }}
{ MERGEFIELD Invoice No } { MERGEFIELD Date}
{ If { Place2 } <> { Place1 }"------page break

Date : {Date \@" dd-MM-yyyy" \* MERGEFORMAT }
"{ MERGEFIELD Name }

I have herewith attached all Invoices and relevant dates which are pending. Please made arrangements as soon.


Kind Regards,
Paul Samson - Recovery Manager" "" }
{ SET Place2 { MERGEFIELD Customer No }}

The above code produces output as follows.


Date : 15-07-2021

Dear John Allen,

I have herewith attached all Invoices and relevant dates which are pending. Please made arrangements as soon.


Kind Regards,
Paul Samson - Recovery Manager

EX4565 25-Mar-21
EX4591 29-Mar-21
EX4674 20-Apr-21
EX4679 13-May-21
EX4700 29-May-21
EX4791 10-Jun-21
EX4824 14-Jun-21
EX4891 21-Jun-21
EX4923 2-Jul-21
EX5110 13-Jul-21
EX5192 24-Jul-21

But I want the to prepare my letter as records in one row since I have many invoices for each customer.

Required Letter like this
Date : 15-07-2021

Dear John Allen,

I have herewith attached all Invoices and relevant dates which are pending. Please made arrangements as soon.


Kind Regards,
Paul Samson - Recovery Manager

EX4565 25-Mar-21 EX4591 29-Mar-21 EX4674 20-Apr-21
EX4679 13-May-21 EX4700 29-May-21 EX4791 10-Jun-21
EX4824 14-Jun-21 EX4891 21-Jun-21 EX4923 2-Jul-21
EX5110 13-Jul-21 EX5192 24-Jul-21

Can someone please point me out a solution to get this done.


Many Thanks
Ben
Reply With Quote
  #2  
Old 07-23-2021, 08:53 PM
gmayor's Avatar
gmayor gmayor is offline Multiple Records in Mail Merge Document in MS Word Windows 10 Multiple Records in Mail Merge Document in MS Word Office 2019
Expert
 
Join Date: Aug 2014
Posts: 3,551
gmayor is a splendid one to beholdgmayor is a splendid one to beholdgmayor is a splendid one to beholdgmayor is a splendid one to beholdgmayor is a splendid one to beholdgmayor is a splendid one to behold
Default

See Merge Many To One
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple Records in Mail Merge Document in MS Word Mail Merge with multiple records prasademany Mail Merge 7 05-08-2020 05:55 AM
Multiple Records in Mail Merge Document in MS Word Mail Merge Grouping Multiple Records into 1 Output DeniseStafiej Mail Merge 1 08-03-2018 03:41 PM
Multiple Records in Mail Merge Document in MS Word Many records to One Mail Merge Document CONFUSEDOPSMANAGER Mail Merge 1 05-08-2017 02:56 PM
Multiple Records Mail Merge using Email Skybluekid Mail Merge 1 03-28-2016 02:33 PM
Multiple Records in Mail Merge Document in MS Word 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 08:18 AM.


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