473,326 Members | 2,013 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,326 software developers and data experts.

2 data files for mail merge into WORD?

I have searched the archives for answers with no luck.
I am now using Access 2003 from Lotus Approach.
I see that Access does not have any built in envelope or mailing lable
features.
I want to have a standard letter that I use with a mailing label.

I tried WORD for the mail merge but I have my contact data in one data
file (table) and my projects in a different data file (table) . So my
standard letter which is a transmittal needs to see both the contact
and project names and numbers to insert into the page. WORD only let
me use 1 data file. Any work arounds for this problem?

Jan 14 '06 #1
2 3390
On 14 Jan 2006 13:31:01 -0800, gtslabs wrote:
I have searched the archives for answers with no luck.
I am now using Access 2003 from Lotus Approach.
I see that Access does not have any built in envelope or mailing lable
features.
I want to have a standard letter that I use with a mailing label.

I tried WORD for the mail merge but I have my contact data in one data
file (table) and my projects in a different data file (table) . So my
standard letter which is a transmittal needs to see both the contact
and project names and numbers to insert into the page. WORD only let
me use 1 data file. Any work arounds for this problem?

I see two solutions:
1. Make a query based on the two tables, and use that as datasource.

2. Drop mailmerge, and let access create the word documents using vba and
automation.

--
Regards
Benny Andersen
Jan 14 '06 #2
If your "projects" data is only going to be ONE record of data that you need
to merge along with the contact information, then you simply build a form
based on the projects table that also pulls in the contact information.

You then use find, or browse tot he correct record..and then click on the
word merge button...you are done!!

The super easy word merge button code and library of mine can be downloaded
here:

http://www.members.shaw.ca/AlbertKal.../msaccess.html

So, if you can select ONE project..then my above merge code will do the
trick for you (just build a query based on the projects table..and also
based on the contacts table - then build a form based on the query..and then
use my above merge system).
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
http://www.members.shaw.ca/AlbertKallal
Jan 17 '06 #3

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

Similar topics

4
by: Andrew | last post by:
Hi Experts, I have a DB containing many records of customers' info. How can I pull these data to the MS Word mail merge letters containing the header (name, address, etc) and contents...
0
by: mark | last post by:
Software: Office XP Systeem: Win 2000 I'v been trying to merge an access database OLE field (containing RTF text) into a word doc. The mail merge works OK, all database fields are added...
3
by: intl04 | last post by:
Is it possible to create a Word form as the data entry form for an Access database? I didn't see any reference to this possibility in my Access books, so I'm sorry if this is a question that is...
0
by: Julia Baresch | last post by:
Everyone, I posted the message below back in February and didn't get any information. I also wasn't able to find any documentation in MS Help, web site, or other groups. I'm posting now with...
1
by: Lisa | last post by:
I have a query named QryDept where one of the fields is DeptID. The query is used for the data source of a mail merge letter. I would like to control which department is to get the mail merge...
7
by: Andy Davis | last post by:
I have a table of data in Access 2002 which is used as the source table for a mail merge document using Word 2002 on my clients PC. The data is transferred OK but I've noticed that any dates which...
1
by: John Welch | last post by:
I'm trying to use the Mergit() function from the MS Knowledge base article to merge data from a query or table in my Access 2000 mdb into an existing word merge document. Every time it runs it...
2
by: JeffN825 | last post by:
Hello, Thank you in advance for any assistance. I am trying to set up a mail merge from VB6/VBA code with Word 2000 using an ODBC data source (SQL 2000). I have successfully gotten the...
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
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
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...
1
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...
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: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

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.