Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
sajara sajara is offline
external usenet poster
 
Posts: 9
Default merging two data source files

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!
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default merging two data source files

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.

--
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

"sajara" wrote in message
...
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!



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Appending/merging .mdb data source files joyceD Microsoft Word Help 1 January 19th 07 09:21 PM
Not merging all records from an Excel data source CMEC Mailmerge 3 December 8th 06 06:41 PM
Changes are not reflected when merging using Excel as data source Jennifer Mcdermeit Mailmerge 2 July 20th 06 07:36 PM
merge document and data source are not merging Deb in Minnesota Mailmerge 1 December 1st 05 06:31 PM
Merging hyper link from data source Jasy Mailmerge 3 June 1st 05 12:58 PM


All times are GMT +1. The time now is 01:40 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"