Sign in to follow this  
Followers 0
johnwon

Microsoft Access 2007 Navigation

2 posts in this topic

I use Microsoft Access to send automated emails to our employees to have them update information. They update their info and then submit it back and Outlook writes the changes to the Access Database automatically. This feature works really well and allows about 400 people to submit daily updates.

I'd like to automate this task using AutoIt so that the emails are sent before we arrive at work daily, otherwise, people are waiting on me in the morning and I don't want to use mouse clicks due to the unrelabable nature of them over time.

The issue is that I need to click on the External Data tab, then click on the table with my data to highlight it, then click on Create E-mail (on the ribbon). I can't figure out how to tell it to highlight my table name tbl_calls_to_make. If I could get the curser to focus on the All Access Objects window (OMain class), then I could issue x number of tabs to get there I guess, but I can't get Access to switch to that class (it stays on the splash form).

I think I can get everything else to work from this point forward. Any suggestions on how to highlight the table name would be greatly appreciated.

Share this post


Link to post
Share on other sites



Look at the functions in Access.au3

I think there is a newer version of the UDF but I'm not sure.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0