Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge?
I would like to add 'values' or costs from a seperate spreadsheet to an
already mail merged document (contact list merge). can i do this? how? or would i need to add a 'tag' of some sort to insert values? This document i merged is over 300 word pages! would i need to go back into excell and put the two differnt spreadsheets into one book? i am not a I.T person at all and would appreciate any help. Thank You. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge?
can i do this?
Only by cut-and-pasting a lot. would i need to go back into excell and put the two differnt spreadsheets into one book? It sounds like you may need to do something like that, but it depends on exactly what you need to do. If your contact list is already in one spreadsheet, and your sepearte spreadsheet has one row for each contact, and you can sort the two so they are in the same sequence, then you can probably just copy the column(s) you need from the "values" sheet into the contacts sheet and use that to do a new mailmerge based on your existing mail merge main document. Otherwise I think it would be helpful if you could say more about your two data sources. Peter Jamieson "mbtn" wrote in message ... I would like to add 'values' or costs from a seperate spreadsheet to an already mail merged document (contact list merge). can i do this? how? or would i need to add a 'tag' of some sort to insert values? This document i merged is over 300 word pages! would i need to go back into excell and put the two differnt spreadsheets into one book? i am not a I.T person at all and would appreciate any help. Thank You. |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge?
Peter,
thank you for replying. i have merged a general word letter with my contact list (from excell). I now need to personalize these letters with the value of their costs (FYE). this is in another excell spreadsheet. however the trick is that this list of people with costs is not as complete as my word contacts. so i also need to ensure the merge can recognise the costs to the right contact! my only other option is to do this indiviually! Help!! "Peter Jamieson" wrote: can i do this? Only by cut-and-pasting a lot. would i need to go back into excell and put the two differnt spreadsheets into one book? It sounds like you may need to do something like that, but it depends on exactly what you need to do. If your contact list is already in one spreadsheet, and your sepearte spreadsheet has one row for each contact, and you can sort the two so they are in the same sequence, then you can probably just copy the column(s) you need from the "values" sheet into the contacts sheet and use that to do a new mailmerge based on your existing mail merge main document. Otherwise I think it would be helpful if you could say more about your two data sources. Peter Jamieson "mbtn" wrote in message ... I would like to add 'values' or costs from a seperate spreadsheet to an already mail merged document (contact list merge). can i do this? how? or would i need to add a 'tag' of some sort to insert values? This document i merged is over 300 word pages! would i need to go back into excell and put the two differnt spreadsheets into one book? i am not a I.T person at all and would appreciate any help. Thank You. |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge?
If it's a one-off, frankly, your best bet is to insert the values manually,
even though there are a lot of them. Another approach if there are not many rows "missing" from your second sheet would be to add the missing rows, sort both sheets and combine them. Anything else is probably going to require that you do a lot of steps you may never have done before. I don't know Excel well enough to tell you whether or not there is an easy way to combine your values into a single sheet - I would ask in an Excel group. However you do it, to do it "automatically", your data will need a column in each sheet with a common identifier, e.g. perhaps you have a contact ID or name column that contains the same data for matching rows in the two sheets. If I were doing it, I'd probably just import the data into Access and create a query that joins the two tables. But maybe you don't have Access. In that case, if MS Query is installed on your system (it is optionally installed when you run Office setup) you should be able to open a new spreadsheet, go into the Excel Data menu and use Import External Data|New Database Query. You would then need to work out how to define a query involving your two sheets (which MS Query sees as "tables") , "joining" them using the common identifier column. Then save that sheet and use it as your merge source. Peter Jamieson "mbtn" wrote in message ... Peter, thank you for replying. i have merged a general word letter with my contact list (from excell). I now need to personalize these letters with the value of their costs (FYE). this is in another excell spreadsheet. however the trick is that this list of people with costs is not as complete as my word contacts. so i also need to ensure the merge can recognise the costs to the right contact! my only other option is to do this indiviually! Help!! "Peter Jamieson" wrote: can i do this? Only by cut-and-pasting a lot. would i need to go back into excell and put the two differnt spreadsheets into one book? It sounds like you may need to do something like that, but it depends on exactly what you need to do. If your contact list is already in one spreadsheet, and your sepearte spreadsheet has one row for each contact, and you can sort the two so they are in the same sequence, then you can probably just copy the column(s) you need from the "values" sheet into the contacts sheet and use that to do a new mailmerge based on your existing mail merge main document. Otherwise I think it would be helpful if you could say more about your two data sources. Peter Jamieson "mbtn" wrote in message ... I would like to add 'values' or costs from a seperate spreadsheet to an already mail merged document (contact list merge). can i do this? how? or would i need to add a 'tag' of some sort to insert values? This document i merged is over 300 word pages! would i need to go back into excell and put the two differnt spreadsheets into one book? i am not a I.T person at all and would appreciate any help. Thank You. |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge?
One of Doug Robbins' messages has reminded me - in Excel you could play
around with the LOOKUP function to try to splice your two sheets together - if you need more help on that, you really do need to ask in an Excel group. Peter Jamieson "Peter Jamieson" wrote in message ... If it's a one-off, frankly, your best bet is to insert the values manually, even though there are a lot of them. Another approach if there are not many rows "missing" from your second sheet would be to add the missing rows, sort both sheets and combine them. Anything else is probably going to require that you do a lot of steps you may never have done before. I don't know Excel well enough to tell you whether or not there is an easy way to combine your values into a single sheet - I would ask in an Excel group. However you do it, to do it "automatically", your data will need a column in each sheet with a common identifier, e.g. perhaps you have a contact ID or name column that contains the same data for matching rows in the two sheets. If I were doing it, I'd probably just import the data into Access and create a query that joins the two tables. But maybe you don't have Access. In that case, if MS Query is installed on your system (it is optionally installed when you run Office setup) you should be able to open a new spreadsheet, go into the Excel Data menu and use Import External Data|New Database Query. You would then need to work out how to define a query involving your two sheets (which MS Query sees as "tables") , "joining" them using the common identifier column. Then save that sheet and use it as your merge source. Peter Jamieson "mbtn" wrote in message ... Peter, thank you for replying. i have merged a general word letter with my contact list (from excell). I now need to personalize these letters with the value of their costs (FYE). this is in another excell spreadsheet. however the trick is that this list of people with costs is not as complete as my word contacts. so i also need to ensure the merge can recognise the costs to the right contact! my only other option is to do this indiviually! Help!! "Peter Jamieson" wrote: can i do this? Only by cut-and-pasting a lot. would i need to go back into excell and put the two differnt spreadsheets into one book? It sounds like you may need to do something like that, but it depends on exactly what you need to do. If your contact list is already in one spreadsheet, and your sepearte spreadsheet has one row for each contact, and you can sort the two so they are in the same sequence, then you can probably just copy the column(s) you need from the "values" sheet into the contacts sheet and use that to do a new mailmerge based on your existing mail merge main document. Otherwise I think it would be helpful if you could say more about your two data sources. Peter Jamieson "mbtn" wrote in message ... I would like to add 'values' or costs from a seperate spreadsheet to an already mail merged document (contact list merge). can i do this? how? or would i need to add a 'tag' of some sort to insert values? This document i merged is over 300 word pages! would i need to go back into excell and put the two differnt spreadsheets into one book? i am not a I.T person at all and would appreciate any help. Thank You. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to get all mail merge fields in a document | Mailmerge | |||
Adding a field to an Off 97 mail merge using Office Pro 2003 | Mailmerge | |||
Mail Merge Losing Data | Mailmerge | |||
mail merge with attachments | Mailmerge | |||
Mail Merge Issue With Office 97 - Excel Data Source | Mailmerge |