473,327 Members | 2,081 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

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

Jan 16 '07 #1
6 4617
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
Jan 16 '07 #2
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

Jan 17 '07 #3
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
Jan 17 '07 #4
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
Jan 18 '07 #5
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

Jan 19 '07 #6
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
Jan 19 '07 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Ecohouse | last post by:
I have a computer with XP on it. I loaded Office 97 first because I needed Access 97 for some work. I then loaded Office 2000. Everything seemed to be running fine. But I have come across a few...
9
by: Neil Ginsberg | last post by:
I have a strange situation using Access to automate a Word mail merge. Using Access 2000 and Word 2000, the code opens Word, opens the document in Word, sets a table in the calling Access...
3
by: Strasser | last post by:
In Access2000 mass emailing worked perfectly (very powerful tool!). Doesn't work when using XP version of both Access and Outlook, even though I checked the box to ensure that I was sending the...
3
by: Andy Davis | last post by:
I have set up a mail merge document in Word 2003 which gets its data from my Access 2000 database. I want to set up a button on a form that: 1. runs the query to provide the dat for the merge...
4
by: pmhaupt2 | last post by:
I developed an Access 2003 program that will allow the user to produce a group of Word letters that merge with data records from an Access database. I created a mail merge Word document and...
0
by: Darragh | last post by:
I'm encountering some serious problems trying to set Access 2000 querys (parameters and views) as data sources for my mail merge documents (Word 2003). After spending hours scouring the web for...
8
by: Ron B | last post by:
Help!!! What am I doing wrong? I am working with Office 2003 and am trying to create a command button on an Access form that will create a mail merge in Word from an Access table. I want to...
1
by: Esther Lane | last post by:
Hello! First off, many many thanks to Albert who wrote the Mail Merge code for MS Access I am using. It has been working beautifully for a few years. However, my client just (without notice!)...
1
by: kirkus84 | last post by:
I am currently trying to do a multiple record mail merge through a query via a command button on a form. The query basically displays customers who have said yes to privacy. The user inputs a date...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.