Access mail merge to word, multiple sources

[crealesmith]

Firstly, I have no problem with mail merging to Word, VB code for that
works perfectly.
On one mail merge I need to merge 15 fields of data that are from 3
seperate records.
The 3 records are all in the same table. If I use a control source that
is selecting the 3 records, all of the data is shown but spread over 3
pages in the mail merge, but needs to be listed together in one
paragraph.

Is there anyway of looping through the 3 selected records and inserting
them into a temporary table that can then be used as the source of the
mail merge?

Are there any other methods that can be used to create the page with
all the data together. I have tried creating a report to display the
data, which works perfectly until it is exported to Word and then
decides to display all the data in a different layout!

I apologise if this is very vague, I will try and be more detailed to
any questions or comments posted.

Many thanks

[aaron.kempf]

use reporting services for mail merge

using word and access mdb is for first-graders

reporting services scales

I just wrote a couple of hundred 'mail merge' reports using Reporting
Services

-Aaron


cr*********@googlemail.com wrote:

Firstly, I have no problem with mail merging to Word, VB code for that
works perfectly.
On one mail merge I need to merge 15 fields of data that are from 3
seperate records.
The 3 records are all in the same table. If I use a control source that
is selecting the 3 records, all of the data is shown but spread over 3
pages in the mail merge, but needs to be listed together in one
paragraph.

Is there anyway of looping through the 3 selected records and inserting
them into a temporary table that can then be used as the source of the
mail merge?

Are there any other methods that can be used to create the page with
all the data together. I have tried creating a report to display the
data, which works perfectly until it is exported to Word and then
decides to display all the data in a different layout!

I apologise if this is very vague, I will try and be more detailed to
any questions or comments posted.

Many thanks

[RobinS]

I don't know the answer to your question, but I thought I'd
post and recommend that you ignore aaron; he's just messing with you.
Robin S.
--------------------------------------------
<cr*********@googlemail.comwrote in message
news:11**********************@s34g2000cwa.googlegr oups.com...

Firstly, I have no problem with mail merging to Word, VB code for that
works perfectly.
On one mail merge I need to merge 15 fields of data that are from 3
seperate records.
The 3 records are all in the same table. If I use a control source
that
is selecting the 3 records, all of the data is shown but spread over 3
pages in the mail merge, but needs to be listed together in one
paragraph.

Is there anyway of looping through the 3 selected records and
inserting
them into a temporary table that can then be used as the source of the
mail merge?

Are there any other methods that can be used to create the page with
all the data together. I have tried creating a report to display the
data, which works perfectly until it is exported to Word and then
decides to display all the data in a different layout!

I apologise if this is very vague, I will try and be more detailed to
any questions or comments posted.

Many thanks

[Chris]

I would like to use a faster method, but unfortunately my boss wants it
this way!

aa*********@gmail.com wrote:

use reporting services for mail merge

using word and access mdb is for first-graders

reporting services scales

I just wrote a couple of hundred 'mail merge' reports using Reporting
Services

-Aaron


cr*********@googlemail.com wrote:

Firstly, I have no problem with mail merging to Word, VB code for that
works perfectly.
On one mail merge I need to merge 15 fields of data that are from 3
seperate records.
The 3 records are all in the same table. If I use a control source that
is selecting the 3 records, all of the data is shown but spread over 3
pages in the mail merge, but needs to be listed together in one
paragraph.

Is there anyway of looping through the 3 selected records and inserting
them into a temporary table that can then be used as the source of the
mail merge?

Are there any other methods that can be used to create the page with
all the data together. I have tried creating a report to display the
data, which works perfectly until it is exported to Word and then
decides to display all the data in a different layout!

I apologise if this is very vague, I will try and be more detailed to
any questions or comments posted.

Many thanks

[aaron.kempf]

your boss doesn't understand that

a) word isn't a reporting platform
b) MDB isn't a reasonable database

lose the training wheels and learn SQL Server

I just wrote abotu 50 mail merges in reporting services in a period of
about 2 months; but now that I'm up to speed it would probably take me
less time to do it in RS than it would take you do it in Word.

If you want to do a mail merge from 3 data sources, use SQL Server
Reporting Services.

-Aaron

Chris wrote:

I would like to use a faster method, but unfortunately my boss wants it
this way!

aa*********@gmail.com wrote:

use reporting services for mail merge

using word and access mdb is for first-graders

reporting services scales

I just wrote a couple of hundred 'mail merge' reports using Reporting
Services

-Aaron


cr*********@googlemail.com wrote:

Firstly, I have no problem with mail merging to Word, VB code for that
works perfectly.
On one mail merge I need to merge 15 fields of data that are from 3
seperate records.
The 3 records are all in the same table. If I use a control source that
is selecting the 3 records, all of the data is shown but spread over 3
pages in the mail merge, but needs to be listed together in one
paragraph.
>
Is there anyway of looping through the 3 selected records and inserting
them into a temporary table that can then be used as the source of the
mail merge?
>
Are there any other methods that can be used to create the page with
all the data together. I have tried creating a report to display the
data, which works perfectly until it is exported to Word and then
decides to display all the data in a different layout!
>
I apologise if this is very vague, I will try and be more detailed to
any questions or comments posted.
>
Many thanks

[RobinS]

If nobody here can help you, try posting to the Office
programming newsgroup(s).

Robin S.
-------------------
"Chris" <cr*********@googlemail.comwrote in message
news:11*********************@a75g2000cwd.googlegro ups.com...

>I would like to use a faster method, but unfortunately my boss wants it
this way!

aa*********@gmail.com wrote:

>use reporting services for mail merge

using word and access mdb is for first-graders

reporting services scales

I just wrote a couple of hundred 'mail merge' reports using Reporting
Services

-Aaron


cr*********@googlemail.com wrote:

Firstly, I have no problem with mail merging to Word, VB code for
that
works perfectly.
On one mail merge I need to merge 15 fields of data that are from 3
seperate records.
The 3 records are all in the same table. If I use a control source
that
is selecting the 3 records, all of the data is shown but spread
over 3
pages in the mail merge, but needs to be listed together in one
paragraph.

Is there anyway of looping through the 3 selected records and
inserting
them into a temporary table that can then be used as the source of
the
mail merge?

Are there any other methods that can be used to create the page
with
all the data together. I have tried creating a report to display
the
data, which works perfectly until it is exported to Word and then
decides to display all the data in a different layout!

I apologise if this is very vague, I will try and be more detailed
to
any questions or comments posted.

Many thanks

[aaron.kempf]

don't listen to this dyke; im correct

if you want to mail merge in the year 2007; then just use Reporting
Services

-Aaron

RobinS wrote:

If nobody here can help you, try posting to the Office
programming newsgroup(s).

Robin S.
-------------------
"Chris" <cr*********@googlemail.comwrote in message
news:11*********************@a75g2000cwd.googlegro ups.com...

I would like to use a faster method, but unfortunately my boss wants it
this way!

aa*********@gmail.com wrote:

use reporting services for mail merge

using word and access mdb is for first-graders

reporting services scales

I just wrote a couple of hundred 'mail merge' reports using Reporting
Services

-Aaron


cr*********@googlemail.com wrote:
Firstly, I have no problem with mail merging to Word, VB code for
that
works perfectly.
On one mail merge I need to merge 15 fields of data that are from 3
seperate records.
The 3 records are all in the same table. If I use a control source
that
is selecting the 3 records, all of the data is shown but spread
over 3
pages in the mail merge, but needs to be listed together in one
paragraph.

Is there anyway of looping through the 3 selected records and
inserting
them into a temporary table that can then be used as the source of
the
mail merge?

Are there any other methods that can be used to create the page
with
all the data together. I have tried creating a report to display
the
data, which works perfectly until it is exported to Word and then
decides to display all the data in a different layout!

I apologise if this is very vague, I will try and be more detailed
to
any questions or comments posted.

Many thanks