Trying to perform a mail merge into a MS Word Table from Access

[Technyc2003]

Could really use some help with this problem. I'm trying to perform a mail merge into a Microsoft Word Table template from an Access Database.

I created this template form that has 8 columns and 20 rows. Now when I click the button to perform the mail merge it works fine. BUT!!! the problem is that it puts 20 of the same clients name in each one of those rows where it’s suppose to put all the clients in the rows not just 1 person x 20.

I have about 150 clients in my access database which once the mail merge completes I should have about 8 pages.


Thank you.

Robert

 

[koresnordic]

use the nextrecord command to move to the next record for merging. it is a standard merge field and not one from your database. On the merge toolbag - select the insert word field and pick next record



Graham

 

[Technyc2003]

I'm not too sure what you mean this is how I have the form setup right now.

«ClientNo» «PatientName» «Birthdate» «Gender»

and what I've done is copy and pasted those fields into each
row of my MS Word template form table.

I don't use the Access Database for anything right now I just created a table and inputted all the client data. I'm in the testing phase to make sure the merge works and then I'll customize the database once I see this works.

 

[koresnordic]

add the word field «Next Record» prior to the second and subsequent cells. this will move the data onto the next record of the data.



Graham

 

[Technyc2003]

I think I got it, I put the <<Nextrecord>> after the ClientNo field only and did a test and I see each client the way it's suppose to be.

On last thing my friend, how do I tell it to sort alphabetically by my Patient's Name?

 

[gizmo1973]

Sort your source data by patient name

Regards, Phil.

M.U.F.C. Show your true support here:

http://www.shareholdersunited.org/join.php

"Shares not Shirts

 

[Technyc2003]

Phil, thank you very much, you are The Man!!!