Using Word to resolve values defined in a csv file

  • Thread starter Thread starter A1sysman
  • Start date Start date
A

A1sysman

Hi all,

Can Word be configured to use a csv lookup table or an Excel spread sheet?

Below are examples of the specifics:

Source in the Word doc …

<Sponsor>1233</Sponsor>
<Sponsor>44</Sponsor>

Target output after using the look up …

<Sponsor>JOHN BROWN</Sponsor>
<Sponsor>PAUL WHITE</Sponsor>

Where there is a csv file generated from an Excel spreadsheet, that reads…

Brown,John,1233
White,Paul,44
Green,Nick,9062
.... and so on.

If the answer is "yes, Word can do this", how please?

Thanks,

A1sysman
 
I believe you would have to write a VBA program that opens the lookup file
and processes it. That would be much easier to do with the lookup in an Excel
spreadsheet rather than a csv.
 
Ok, thanks for your reply and suggestion.

I was thinking more along the lines of whether it is possible to use a Word
macro to use a csv file in order to resolve UINs to names, then to continue
on and use seach and replace of the UINs with a reorder of the date by way of
field 2 {space} field1 capitalised, omitting field 3.

Does that make sense? I'm too lightweight a user of Word to know if this is
possible or, if it is, how to do it!


Rgds,

N
 
Back
Top