Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
combining data sources
I have a multicolumn table (using MSWord 2003). In the first column of each
row, there is a number. I'd like to use this number to "lookup" the same value in an Excel spreadsheet (which has two columns of data: column 1-numbers; column 2-names). I'd like to insert the corresponding name in the Word table (in the column to the right of number column) Is this possible with mailmerge? Should I be doing it with a macro instead? (I'd do the whole thing in Excel, but I need the text-formatting capabilities of Word.) Thanks for any suggestions. Bert |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
combining data sources
The easiest thing is probably to do the combining in Excel (using a lookup
function) and then copy and paste it back into Word for the formatting. For a macro based alternative, see the article "Access a database and insert into a Word document the data that you find there" at: http://www.word.mvps.org/FAQs/InterD...DataFromDB.htm -- 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, originally posted via msnews.microsoft.com "Bert" wrote in message ... I have a multicolumn table (using MSWord 2003). In the first column of each row, there is a number. I'd like to use this number to "lookup" the same value in an Excel spreadsheet (which has two columns of data: column 1-numbers; column 2-names). I'd like to insert the corresponding name in the Word table (in the column to the right of number column) Is this possible with mailmerge? Should I be doing it with a macro instead? (I'd do the whole thing in Excel, but I need the text-formatting capabilities of Word.) Thanks for any suggestions. Bert |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
combining data sources
Thanks, Doug.
If I decide to go the VBA route, this will get me started. Bert "Doug Robbins - Word MVP on news.microsoft.com" wrote in message ... The easiest thing is probably to do the combining in Excel (using a lookup function) and then copy and paste it back into Word for the formatting. For a macro based alternative, see the article "Access a database and insert into a Word document the data that you find there" at: http://www.word.mvps.org/FAQs/InterD...DataFromDB.htm -- 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, originally posted via msnews.microsoft.com "Bert" wrote in message ... I have a multicolumn table (using MSWord 2003). In the first column of each row, there is a number. I'd like to use this number to "lookup" the same value in an Excel spreadsheet (which has two columns of data: column 1-numbers; column 2-names). I'd like to insert the corresponding name in the Word table (in the column to the right of number column) Is this possible with mailmerge? Should I be doing it with a macro instead? (I'd do the whole thing in Excel, but I need the text-formatting capabilities of Word.) Thanks for any suggestions. Bert |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merging from 3 data sources | Mailmerge | |||
My Data Sources | Microsoft Word Help | |||
data sources | New Users | |||
merging 2 data sources | Mailmerge | |||
multiple data sources and data form | Mailmerge |