Word Macro to reference excel or access table

[newestAF]

I have a word macro that separate different documents attached in one attachment. There are several different documents this works for. I use a word macro to split the docs and save individually. Part of the name saving function is to search the document for the agency name by it's code. I have an excel spreadsheet which I want to import into access to reference. How can I get the macro to reference this xls or table to change the agency name's code to the admin agency cleartext?

 

[SkipVought]

Hi,

If this question is regarding VBA code for a macro, please post in forum707.

When you repost in forum707, please include more detail about how the data in Excel relates to your document.

You also mention 'attachments.' Does this task involve Outlook?

Please address EACH OF THESE QUESTIONS when you report in forum707.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}