Dear all

I am in a fix i need mail merge through Excel and Word document based on criteria. I need to know how should I proceed for this task: The detail are as follows:

https://www.dropbox.com/s/frg2m87jkf...Merge.zip?dl=0

Please help me.

Regards

Shehbaz H.

If you want a separate line for each record, then run a directory merge to a new document and add the headings to that document.

If you want a separate line for each person then this is a Many to One merge. You could investigate Paul's MailMergeTips at the top of this forum, or you could use http://www.gmayor.com/ManyToOne.htm and merge into a borderless table (see the example in that link).

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

Sir, Can you solve my problem?

You can use Word's Catalogue/Directory Mailmerge facility for this (the terminology depends on the Word version). To see how to do so with any mailmerge data source supported by Word, check out my Microsoft Word Catalogue/Directory Mailmerge Tutorial at:
http://windowssecrets.com/forums/showthread.php/154370-Microsoft-Word-Catalogue-Directory-Mailmerge-Tutorial
or:
http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip
The tutorial covers everything from list creation to the insertion & calculation of values in multi-record tables in letters and includes working field codes for the various examples, plus macros where applicable. Do read the tutorial before trying to use the mailmerge document included with it.

For some worked examples, see the attachments to the posts at:
https://www.msofficeforums.com/mail-merge/9180-mail-merge-duplicate-names-but-different-dollar.html#post23345
https://www.msofficeforums.com/mail-merge/11436-access-word-creating-list-multiple-records.html#post30327
http://windowssecrets.com/forums/showthread.php/157725-Word-2010-Merge-from-excel-into-Table-Directory?p=928391&viewfull=1#post928391

Alternatively, you may want to try one of the Many-to-One Mail Merge add-ins, from:
Graham Mayor at http://www.gmayor.com/ManyToOne.htm; or
Doug Robbins at http://bit.ly/1hduSCB

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Sir, i have tried to display records in directory mode but my file is not working. Kindly rectify my mistake. My keyfield is clientid. I want to display five fields i.e. Applicant, Address, Borough, Block, Lot. I want to display records based on Client ID on each page.

Here is the template and Excel file:

https://www.dropbox.com/s/d6d7f1s7g2...t_MM.docx?dl=0
https://www.dropbox.com/s/ay790xu0vp....18s.xlsx?dl=0

Kind Regards

Shehbaz H.

Can anyone help?

There is no indication in your document that you have made any attempt to implement anything from the tutorial. You don't even have any fields in the document - just plain text with braces instead of fields!!! Please don't expect others to do your work for you.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Yes Sir, You are right we must do our work own. Here is attached file where Directory Mail Merge fields are showing. The data source file is the same which i have attached earlier.

I need your help how to display the per page listings based on each Clientid. Please help. I also want to understand the logic of the code which will be used for getting the solution.

https://www.dropbox.com/s/84sg8zcu8jztkhl/aa.docx?dl=0

Kind Regards

Shehbaz

Dear Sir,

Hi

I am continusously trying to figure it out but facing problems. You are my teacher sir i need your help. I am stuck with code which is not working below is the screencast.

http://screencast.com/t/ZjJOOr7WyVY

Please guide me where is my mistake?

Kindly reply as early as possible.

Kind Regards

Shehbaz H.

I really don't know why you bother posting links to documents and videos that serve only to show that you've completely ignored all the advice you've been give. Perhaps it's because you enjoy wasting your time and mine...

Furthermore, why do you keep posting links to dropbox, etc., instead of attaching the relevant files to your posts here?

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

i extremely sorry sir i do not want to waste your time. I do not know how to attach a file here this forum. Sir, i have copied the code form Microsoft site and change the merge fields. Your guidance will be highly solicited for me to complete this task. Please do not irritate give a way to make easy this assignment by pointing out my mistakes. I look forward to receive your valuable suggestion as .i was waiting for reply from last two hours

Kind Regards

Sir, if you do not want to help me then where should i go for solution of my problem? What is the purpose of this forum? I am not asking to do my work it is my request to please point out my mistake as how to implement this code?

Regards

Cross-posted at: http://www.techsupportforum.com/foru...e-1034049.html
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184

You have been advised about the cross-post etiquette twice before on this forum:
https://www.msofficeforums.com/mail-...ry-8387-a.html
https://www.msofficeforums.com/mail-...same-page.html
and you've had multiple reminders on other forums as well.

You also say you "have copied the code form Microsoft site and change the merge fields", but nothing I have guided you to is on any Microsoft site. That's a pretty clear indication you're not paying attention to any advice you've been given here, so you're still just wasting everyone's time.

Thread closed.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]