Lookup

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RNG - 11 Dec 2005 04:33 GMT

Greetings:
I have a mail merge process that print some address. The problem I am having
is that I am receiving the country code and not the full name of the
corresponding country code.

I cannot change the data source to include the full name. I know that in
mail merge I cannot access 2 datasource. Can I have some kind of lookup
function that I could use to transform the country code to its full name?

Any advise is welcome.

Thanks

Reply to this Message

Doug Robbins - Word MVP - 11 Dec 2005 08:04 GMT

I think that your best bet will be to execute the merge to a new document
and then use Edit>Replace to replace the country codes with the full name.
If there are not too many countries involved, or you don't need to do it on
a regular basis, a series of manual Edit>Replaces will probably not be too
much trouble. If there are more countries or this is a regular task, then
it might be worth developing a macro to do a series of Edit>Replaces by
iterating through a table that contains the codes and the full names to get
the findtext and replacementwith text to use.

Signature

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

> Greetings:
> I have a mail merge process that print some address. The problem I am
[quoted text clipped - 9 lines]
>
> Thanks

Reply to this Message