Access email data collection - customize in VBA?

Dear experts -
We need to regularly send out large numbers of emails, with an embedded simple form, or link to a web page with a few questions.
The Access 2010 email data collection wizard (with Outlook link) seems perfect for us - IF we could customize it (e.g., not use the Wizard but do everything via VBA, specify programmatically which email account was used to send the emails - ideally off central server's generic account, etc. etc.).
I can't seem to find anything relevant online.
Anyone know the answer to this?
If it can't be done, what is our best alternative that we should look at? Is there a third-party add-on that might help?
THANKS!
terpsichoreAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

terpsichoreAuthor Commented:
Does it include ability to receive back data?
0
terpsichoreAuthor Commented:
I read the specs on your product but don't see anything related to collecting data, which is our main issue.
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
I would look to other methods.  The data collection feature has already been dropped in the product as of A2013 and there is no VBA control of the process in A2007/A2010.

With that said, certainly what the wizard does you could do.   With VBA, you can read incoming e-mails from a POP3 mail server either directly or through Outlook.

I'm not aware of any 3rd party offerings that currently have anything like this.

 Most data collection setups use a web form to collect data and a e-mail to invite and send a link.

Jim.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jeffrey CoachmanMIS LiasonCommented:
<We need to regularly send out large numbers of emails, >
Then know that a lot of generic spam filters may block you because they see you spitting out "large numbers of emails"
Perhaps this is not an issue, ...just mentioning it.

<with an embedded simple form>
...to do what exactly?

<specify programmatically which email account was used to send the emails - ideally off central server's generic account, etc. etc.).>
Then you need to ask your Exchange Server admin about: SendAs and SendOnBehalfOf.
You can read a bit about both here:
http://www.shudnow.net/2007/08/12/send-on-behalf-and-send-as/

As Jim stated, there is a great deal you can automate in Access as far as emailing goes.
But if you are looking for a way to "collect data" specifically, then this is not something you would want to tackle on your own, ...if you are new to the outlook VBA object model.

So if the wizard in Access 2010 does what you need, then I would stick with that.
But in the mean time, I would investigate other option (also as Jim stated)

JeffCoachman
0
terpsichoreAuthor Commented:
Just what I was looking for, thanks!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.