Word 2003 Mail Merge

[Reed]

Mail merging records from Access. I am merging multiple records into the same
document. This works fine until I need to place fields from the same record
in different places in the document. ie I first list the name fields from
multiple records and later in the document I need to insert other information
(fields) from the same set of records. If I simply add to code to merge the
other fields, I just get blanks.

I need to be able to have the merge do a sort of global "next" on the whole
database.
Like "go to first record in the database and continue"...

Any idea would help.

Thanks

 

[Peter A]

Mail merging records from Access. I am merging multiple records into the same
document. This works fine until I need to place fields from the same record
in different places in the document. ie I first list the name fields from
multiple records and later in the document I need to insert other information
(fields) from the same set of records. If I simply add to code to merge the
other fields, I just get blanks.

I need to be able to have the merge do a sort of global "next" on the whole
database.
Like "go to first record in the database and continue"...

Any idea would help.

Thanks

It's not clear what you are trying to do. When you say "list the name
fields from multiple records" it sounds like you might now know how
merge works. Each final document, after the merge, will contain data
from one record. I don't think it's possible to end up with data from
multiple records in one document.

 

[Reed]

It's not clear what you are trying to do. When you say "list the name
fields from multiple records" it sounds like you might now know how
merge works. Each final document, after the merge, will contain data
from one record. I don't think it's possible to end up with data from
multiple records in one document.

I have merged multiple records into the same document using the Word Field
"next" and "next if", so it is possible. However, I would know if there is a
code or Word Field that will reset the start position of "next" record>

 

[Doug Robbins - Word MVP]

There is no way of going back to the first record.

See response to your post in the mail merge fields newsgroup.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[CyberTaz]

As Doug said, there isn't a way to do anything like that with mail merge
features. I would think you need to create an Access query that pulls the
data in that manner based on whatever the unique factor is that would cause
the record to be called multiple times. That query can then be used as a
record source to generate the merge. I'm having trouble visualizing such a
record set, though.

Regards |:>)
Bob Jones
[MVP] Office:Mac