export/import by email

[sue tang]

I have created a database that I add referrals to, each referral goes to a different person. I created a query for each referral so that I can send the form by email and collect the data by return email. Is there an easier way?

thanks.

[June7]

Are you using Collect Data wizard? Review http://office.microsoft.com/en-us/ac...010252713.aspx

[sue tang]

yes, I'm using the collect data wizard.

[June7]

Other than having users input directly to the database, perhaps through a web application, I don't see any easier way for the users. The web app might be harder on the developer (you). I have never built one. Sharepoint is supposed to be a tool for that.

[sue tang]

yes, I understand sharepoint would be the optimum way to do this, however, our IT department has not released sharepoint to the "common" user as yet. Can a macro be created that will run the "create email" function and all it's prompts?

thanks

[June7]

I use VBA to send email but it is not Collect Data. Review http://forums.aspfree.com/microsoft-...ro-447084.html