Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I mail merge to EMAIL from MS Word AND add a pdf attachment | Mailmerge | |||
How do I create a read-only mail merge data source? | Mailmerge | |||
Can you do a mail merge using multiple data sources? | Mailmerge | |||
data and header sources in mail merge | Mailmerge | |||
Can I mail merge using two or more data sources | Microsoft Word Help |