[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 €¦

Sponsor1233/Sponsor
Sponsor44/Sponsor

Target output after using the look up €¦

SponsorJOHN BROWN/Sponsor
SponsorPAUL 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

[TedMi]

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.
--
TedMi

[A1sysman]

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

"tedmi" wrote:

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.
--
TedMi