Mail Merge? Maybe something else?

[Matt]

Hi All,

I want to do the following:
1). Create a Word Document that has set text and placeholders for
information in my database.
2.) Write a query that returns some records.
3.) Fill the word document with these records.

So, for example, if the query returns 100 records, I want to create a
word document for each record. This word document will be the same
except for a few different fields. I do not care if it is 100 pages
in one word document, or 100 different word documents.

Is this possible?
Is there a different route I should take?
Any Suggestions to this problem?

Thanks all!!

[Tom van Stiphout]

On 18 Apr 2007 12:27:39 -0700, Matt <md*******@yahoo.comwrote:

Mail-merge from Word seems to be the ticket. Turn on the Mail-Merge
toolbar, and spend a few minutes with the help file.

You can automate the use of Word's mailmerge from Access, but that is
a more advanced topic.

-Tom.

>Hi All,

I want to do the following:
1). Create a Word Document that has set text and placeholders for
information in my database.
2.) Write a query that returns some records.
3.) Fill the word document with these records.

So, for example, if the query returns 100 records, I want to create a
word document for each record. This word document will be the same
except for a few different fields. I do not care if it is 100 pages
in one word document, or 100 different word documents.

Is this possible?
Is there a different route I should take?
Any Suggestions to this problem?

Thanks all!!

[Last Boy Scout]

Tom van Stiphout wrote:

On 18 Apr 2007 12:27:39 -0700, Matt <md*******@yahoo.comwrote:

Mail-merge from Word seems to be the ticket. Turn on the Mail-Merge
toolbar, and spend a few minutes with the help file.

You can automate the use of Word's mailmerge from Access, but that is
a more advanced topic.

-Tom.

>Hi All,

I want to do the following:
1). Create a Word Document that has set text and placeholders for
information in my database.
2.) Write a query that returns some records.
3.) Fill the word document with these records.

So, for example, if the query returns 100 records, I want to create a
word document for each record. This word document will be the same
except for a few different fields. I do not care if it is 100 pages
in one word document, or 100 different word documents.

Is this possible?
Is there a different route I should take?
Any Suggestions to this problem?

Thanks all!!

Then you can go crazy with comment codes and stored paragraphs.