Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Mommasbroke
 
Posts: n/a
Default Mail merge using two data sources in same document

I'm trying to mail merge a letter that requires information from two
different data sources. I can not put the information from the two different
data sources into one excell spreadsheet because the data does not
necessarily relate, therefore I need to be able to draw the specific
information I need from the two data sources into the letter.
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
 
Posts: n/a
Default Mail merge using two data sources in same document

Mail merge can only use a single, flat file as a datasource. It is very
hard to imagine that there is not some relationship between the records in
your two sources seeing as how you want to combine them in a merged
document.

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

"Mommasbroke" wrote in message
...
I'm trying to mail merge a letter that requires information from two
different data sources. I can not put the information from the two
different
data sources into one excell spreadsheet because the data does not
necessarily relate, therefore I need to be able to draw the specific
information I need from the two data sources into the letter.



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Mommasbroke
 
Posts: n/a
Default Mail merge using two data sources in same document

Thanks Doug for responding.

Yes, there is a relationship between the records that is why I need to use
both.

You see we are a construction company and we use various vendors for
different jobs. I have a data base set up for both vendors and jobs.

I can't create just one data base because that job may not relate to that
vendor or vice versa.



"Doug Robbins - Word MVP" wrote:

Mail merge can only use a single, flat file as a datasource. It is very
hard to imagine that there is not some relationship between the records in
your two sources seeing as how you want to combine them in a merged
document.

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

"Mommasbroke" wrote in message
...
I'm trying to mail merge a letter that requires information from two
different data sources. I can not put the information from the two
different
data sources into one excell spreadsheet because the data does not
necessarily relate, therefore I need to be able to draw the specific
information I need from the two data sources into the letter.




  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
 
Posts: n/a
Default Mail merge using two data sources in same document

To do what you want, you will need to have a field in each datasource that
you can use to link them.

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

"Mommasbroke" wrote in message
...
Thanks Doug for responding.

Yes, there is a relationship between the records that is why I need to use
both.

You see we are a construction company and we use various vendors for
different jobs. I have a data base set up for both vendors and jobs.

I can't create just one data base because that job may not relate to that
vendor or vice versa.



"Doug Robbins - Word MVP" wrote:

Mail merge can only use a single, flat file as a datasource. It is very
hard to imagine that there is not some relationship between the records
in
your two sources seeing as how you want to combine them in a merged
document.

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

"Mommasbroke" wrote in message
...
I'm trying to mail merge a letter that requires information from two
different data sources. I can not put the information from the two
different
data sources into one excell spreadsheet because the data does not
necessarily relate, therefore I need to be able to draw the specific
information I need from the two data sources into the letter.






  #5   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Mommasbroke
 
Posts: n/a
Default Mail merge using two data sources in same document

Can I get that information from the "Help" on Excell?

"Doug Robbins - Word MVP" wrote:

To do what you want, you will need to have a field in each datasource that
you can use to link them.

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

"Mommasbroke" wrote in message
...
Thanks Doug for responding.

Yes, there is a relationship between the records that is why I need to use
both.

You see we are a construction company and we use various vendors for
different jobs. I have a data base set up for both vendors and jobs.

I can't create just one data base because that job may not relate to that
vendor or vice versa.



"Doug Robbins - Word MVP" wrote:

Mail merge can only use a single, flat file as a datasource. It is very
hard to imagine that there is not some relationship between the records
in
your two sources seeing as how you want to combine them in a merged
document.

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

"Mommasbroke" wrote in message
...
I'm trying to mail merge a letter that requires information from two
different data sources. I can not put the information from the two
different
data sources into one excell spreadsheet because the data does not
necessarily relate, therefore I need to be able to draw the specific
information I need from the two data sources into the letter.








  #6   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
 
Posts: n/a
Default Mail merge using two data sources in same document

Probably not. The field in each data source that can be used to link them
is going to be unique to your situation. And, to successfully link (or
join) the two tables together the data in the "link" fields will have to be
unique for each record in both of the data sources. To join them together
using Excel, you would sort each data source on the link fields so that the
records in each are both in the same order (that is so that the first record
in one data source is the record to be linked to the first record in the
other data source Then you can copy and paste the data from one datasource
so that it is alongside the data in the other data source.

Of course if you have a situation where a record in one data source needs to
be linked to more than one record in the other data source, Word cannot
really handle this and you should probably be using a database such as
Access.

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

"Mommasbroke" wrote in message
...
Can I get that information from the "Help" on Excell?

"Doug Robbins - Word MVP" wrote:

To do what you want, you will need to have a field in each datasource
that
you can use to link them.

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

"Mommasbroke" wrote in message
...
Thanks Doug for responding.

Yes, there is a relationship between the records that is why I need to
use
both.

You see we are a construction company and we use various vendors for
different jobs. I have a data base set up for both vendors and jobs.

I can't create just one data base because that job may not relate to
that
vendor or vice versa.



"Doug Robbins - Word MVP" wrote:

Mail merge can only use a single, flat file as a datasource. It is
very
hard to imagine that there is not some relationship between the
records
in
your two sources seeing as how you want to combine them in a merged
document.

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

"Mommasbroke" wrote in message
...
I'm trying to mail merge a letter that requires information from two
different data sources. I can not put the information from the two
different
data sources into one excell spreadsheet because the data does not
necessarily relate, therefore I need to be able to draw the specific
information I need from the two data sources into the letter.








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
How do I mail merge to EMAIL from MS Word AND add a pdf attachment Lily@Insight Mailmerge 24 January 15th 07 10:33 PM
How do I create a read-only mail merge data source? Julie Mailmerge 3 November 16th 05 08:23 PM
Can you do a mail merge using multiple data sources? MatthewLong Mailmerge 1 November 14th 05 09:14 PM
data and header sources in mail merge cp Mailmerge 2 April 1st 05 06:03 PM
Can I mail merge using two or more data sources Caz Microsoft Word Help 1 January 28th 05 05:55 PM


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

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

About Us

"It's about Microsoft Word"