By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,213 Members | 1,307 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,213 IT Pros & Developers. It's quick & easy.

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

P: 2
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?
Jan 23 '08 #1
Share this Question
Share on Google+
3 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
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.
Feb 5 '08 #2

P: 2
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.
Feb 5 '08 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
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 :)
Feb 5 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.