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

Access automation and InfoPath

Expert 100+
P: 234
Here's the low-down - We have an Access 2003 database that tracks employees, including when their reviews are due. The supervisors fill out a paper form and turn it in to an office worker, who enters the data back into the database.

What I'd like to do is to have Access email an InfoPath '03 form to the supervisor for the review, leaving the middleman in this scenario available to get other work done. I'm an Access guru but a total n00b at InfoPath, so I'm not too sure how to go about this. After I create the form template, can Access automate sending a copy to the supervisor?
Feb 13 '09 #1
Share this Question
Share on Google+
3 Replies

Expert 100+
P: 234
Well, now that my company is looking at moving to Office 2007, it looks like I might be able to do this using the feature in Access 2007 which enables the database to collect data directly using a template sent out via Outlook email.
Nov 6 '09 #2

Expert Mod 10K+
P: 14,534
I'm a noob on infopath myself but I would guess that assuming infopath could store/export the form data in csv format it could be referenced by Access. Let us know if you find out any more about this.
Nov 8 '09 #3

Expert 100+
P: 234
InfoPath actually connects directly to the database, which is why I was looking at it in the first place. The problem is with emailing a particular recordset to a particular person. I still can't see how to do that using InfoPath, so I'm hoping that the data collection email feature I've read about in Access '07 will do it.
Nov 9 '09 #4

Post your reply

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