Access mail merge to word, multiple sources | | |
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
| | | | re: Access mail merge to word, multiple sources
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 crealesmith@googlemail.com wrote: Quote:
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
| | | | re: Access mail merge to word, multiple sources
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.
--------------------------------------------
<crealesmith@googlemail.comwrote in message
news:1168960436.983792.249420@s34g2000cwa.googlegr oups.com... Quote:
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
>
| | | | re: Access mail merge to word, multiple sources
I would like to use a faster method, but unfortunately my boss wants it
this way! aaron.kempf@gmail.com wrote: Quote:
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
>
>
>
> crealesmith@googlemail.com wrote: Quote:
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
| | | | re: Access mail merge to word, multiple sources
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: Quote:
I would like to use a faster method, but unfortunately my boss wants it
this way!
> aaron.kempf@gmail.com wrote:
> Quote:
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 crealesmith@googlemail.com wrote: Quote:
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
| | | | re: Access mail merge to word, multiple sources
If nobody here can help you, try posting to the Office
programming newsgroup(s).
Robin S.
-------------------
"Chris" <crealesmith@googlemail.comwrote in message
news:1169064235.724596.43380@a75g2000cwd.googlegro ups.com... Quote:
>I would like to use a faster method, but unfortunately my boss wants it
this way!
> aaron.kempf@gmail.com wrote:
> Quote:
>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
>>
>>
>>
>>
> crealesmith@googlemail.com wrote: Quote:
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
>
| | | | re: Access mail merge to word, multiple sources
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: Quote:
If nobody here can help you, try posting to the Office
programming newsgroup(s).
>
Robin S.
-------------------
"Chris" <crealesmith@googlemail.comwrote in message
news:1169064235.724596.43380@a75g2000cwd.googlegro ups.com... Quote:
I would like to use a faster method, but unfortunately my boss wants it
this way! aaron.kempf@gmail.com wrote: Quote:
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
>
>
>
> crealesmith@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
|  |
| | |  /bytes/about
We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights.
Get the best answers to your questions from over 226,272 network members.
|
