MailMerge Word and Excel Next Record Not Work

Susanto3311
3StarLounger
Posts: 243
Joined: 17 Feb 2022, 05:16

MailMerge Word and Excel Next Record Not Work

Post by Susanto3311 »

hi all..

how to mail merge with excel as data set/source and ms word as document
i have try using Rules but not working (next records)..
here my attachemnt picture
i hope someone give a solution
thanks in advance.

susant
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 78826
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: MailMerge Word and Excel Next Record Not Work

Post by HansV »

That doesn't look like a mail merge. Why not simply copy the Excel dataset and paste it into your Word document?
Best wishes,
Hans

Susanto3311
3StarLounger
Posts: 243
Joined: 17 Feb 2022, 05:16

Re: MailMerge Word and Excel Next Record Not Work

Post by Susanto3311 »

Hi Hans.. That just a sample case.
Please, i want to use mail merge for this case
Actually score1 till score4 as fields.
I hope you have solution using mail merge

User avatar
HansV
Administrator
Posts: 78826
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: MailMerge Word and Excel Next Record Not Work

Post by HansV »

So you could select D1:G5, copy it and paste it into Word.
Best wishes,
Hans

Susanto3311
3StarLounger
Posts: 243
Joined: 17 Feb 2022, 05:16

Re: MailMerge Word and Excel Next Record Not Work

Post by Susanto3311 »

Hi Hans.. I think that's not good idea. Actually in Word document with random position and contains/skip interval row and i have thousand data/records.

User avatar
HansV
Administrator
Posts: 78826
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: MailMerge Word and Excel Next Record Not Work

Post by HansV »

Hmm... anyone else?
Best wishes,
Hans

User avatar
Charles Kenyon
5StarLounger
Posts: 641
Joined: 10 Jan 2016, 15:56
Location: Madison, Wisconsin

Re: MailMerge Word and Excel Next Record Not Work

Post by Charles Kenyon »

This is a weak area for me, but I think you need a catalogue/directory mail merge.
See http://www.msofficeforums.com/mail-merg ... orial.html.
Paul Edstein may see this and be able to give more guidance.

Susanto3311
3StarLounger
Posts: 243
Joined: 17 Feb 2022, 05:16

Re: MailMerge Word and Excel Next Record Not Work

Post by Susanto3311 »

hi charles thank you but it's not easy for me