extract text from macro with VBA/VB.NET - Access 97

[hillside]

I have hundreds of macros that use the SendObject action to email reports to several recipients. I need to compile a list of all recipients for each report. There are around 400 .mdb files with a total of around 4000 reports. Is there a way to programmatically extract the email addresses of the recipients from the macros?

[MMcCarthy]

I have hundreds of macros that use the SendObject action to email reports to several recipients. I need to compile a list of all recipients for each report. There are around 400 .mdb files with a total of around 4000 reports. Is there a way to programmatically extract the email addresses of the recipients from the macros?

I can't think of an easy way of doing this. You could convert the macros to VBA. At least that way you would have easier access to the addresses. The addresses should be comma separated so I would suggest you then copy and paste them to a txt file and import that.

[hillside]

Thanks for your reply.
I ended up using the documenter tool from the tools/analyze menu. Using this tool with the save option I was able to create a table with all the macro information - object names, email addresses, etc. I then used VBA to extract what I needed from that table.

[MMcCarthy]

Thanks for your reply.
I ended up using the documenter tool from the tools/analyze menu. Using this tool with the save option I was able to create a table with all the macro information - object names, email addresses, etc. I then used VBA to extract what I needed from that table.

Thats an even better idea :)