MAIL MERGE MULTIPLE ROWS?

[floydpepper]

Ladies and Gents,
I have a qry that pulls between 1 and 10 records depending on the current work load. I need to enter these into a Word Doc for publishing. I've had some success with Mail Merge, but I have a table in the Word Doc that I need to list multiple entries in. For example, I have:

Name Age Height
John 89 72
Michael 90 71
Bob 98 67

When I do the Mail Merge, it pulls the first record only (Name, Age, Height for John). Is there a way to work around this for multiple listings? Thank you in advance.

FloydP

 

[PaulF]

check out the Word Help File on Catalog.

PaulF

 

[floydpepper]

PaulF,
I'm new. What does that mean (Word Help File on Catalog)? Thanks man.

FloydP

 

[dhookom]

PaulF means open MS Word, select Help from the menu, and type in the word "Catalog".

You could also concatenate the Name, Age, and Height from several records using the generic concatenate function found at

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[floydpepper]

I tried the catalog/directory feature and it performed in two different ways:

1. When I placed the mail merge fields (3) into a table on the Word doc, the file was reproduced 3 times each with one of the records in the first line of the table. I need all three records in the table on one document.

2. I tried it again on a blank document, and it returned with: Record Name Age Record Name Age Record Name Age.

How can I mak ethe fields insert in the format from my initial post?

Thanks again.

FloydP