combining data sources

[Bert]

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

 

[Doug Robbins - Word MVP on news.microsoft.com]

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/InterDev/GetDataFromDB.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]

Thanks, Doug.
If I decide to go the VBA route, this will get me started.
Bert