Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / June 2007

Tip: Looking for answers? Try searching our database.

merging two data source files

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
sajara - 26 Jun 2007 18:06 GMT
Hello,

I have created a data source file for a mail merge using the mail merge
wizard.  The file is saved as a .mdb file.  I would like to have both myself
and another person enter data into the source file by giving each of us an
identical copy of it.  But then I would like to combine the two so that there
is one master list with all the recipients.  I know the easiest way would
probably be to pass the file back and forth, but we need to work on it at the
same time.

Is there a fairly straightforward way to accomplish combining the two files,
which will be identically set up other than the data entered?  I've never
worked with an .mdb file before, so I'm not really familiar with its
functionality.

Thanks in advance!
Doug Robbins - Word MVP - 26 Jun 2007 20:55 GMT
If you do not really need concurrent, simultaneous access, I would use the
data source to create a directory type mailmerge that you merge to a new
document (the only possible destination) and then save that document in a
location to which you both have access.

The directory type mail merge main document should contain just a one row
table into the cells of which you insert the merge fields from you current
data source.  When you execute that merge, the resulting document will
contain a row of data for each record in the data source.  You can then
insert a row at the top of the document and into the cells of that row, you
can insert the names of the merge fields (not the merge fields themselves,
just their names).  If you save that document, you can use it as a data
source.

Note that only one of you will be able to access and use the data source at
the one time, but you will both be able to use it at different times.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Hello,
>
[quoted text clipped - 16 lines]
>
> Thanks in advance!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.