Urgent Solution Sought For Email

[StewartPrince]

Hi,

Firstly, I'm a nube to the forum so if I have posted incorrectly or violated some etiquette then I'm sorry - not intentional.

Question. I know how to generate emails from Access to email recipients but is there a way to just send data via an email to an Access database for the database to collect. My example is this. I have a basic ToDo database that reports to individuals tasks from meetings etc. However, I would like for the team to be able to just send in New Tasks to the database without first having to generate the form request from the database. Ideally, the data request would come from Outlook on their blackBerry or laptop. It would also be great to send a user request by email to the database which would send a report back detailing outstanding actions. I am not looking to create an App or have a front end GUI on the BB device, I want to drive it purely from an email template or the likes?

Anyone help please?

Stew

 

[namliam]

In theory, you can make a email adress that access can go and read every 15 or so minutes... Have the Subject read something like "Run report x" and have some code in place that knows if that email is read, to run this report and send an email back with the report.

I have never done anything along these lines, but in theory it should be possible (I think)

 

[RichP]

I haven't done it myself but it is possible in Access 2007 and 2010 to collect data by email. The link for Access 2010 is here office.microsoft.com/en-us/access-help/add-the-data-collected-through-e-mails-to-your-access-database-HA010341539.aspx

(sorry I'm not up to 10 posts to you'll need to copy and paste that link)

In Access 2013 the 'Collect' group is missing from the Access menu though so I don't know if that is something that they have removed

Good luck

 

[StewartPrince]

Yes, I am aware of collecting data via email - this is driven from the database, the solution I'm working on is sending data from outside the database via email. Thanks for responding

 

[RichP]

Will it still not work for you? You create the initial email that is sent out using Access and that is sent to each person through Outlook on your computer. The emails are just plain HTML and each person stores it in a 'drafts' folder or the such like. Then, when they want to send in a ToDo, they just fill in a copy of the email and send it in. Outlook on your machine will pick it up and send it to Access. As far as I can see you can set Outlook to accept multiple replies from each recipient

The only alternative is to have both Access and Outlook running and set Access to regularly poll a particular Outlook folder. Create an Outlook rule to move all emails with a certain subject into that folder. Then when Access sees a new email it reads the text, processes it and then moves it to another Outlook folder. That is way more painful though and requires moderate amounts of VBA. It's possible though

 

[StewartPrince]

Thanks, you may very well have given me an idea. Good day to you sir

 

[accessvilet]

I've been acheiving this using Access and Microsoft Outlook email. I'Ve been using 1&1 asmy provider and I've been very happy with the service to date. Their technical support is also top notch. They have a range of packages that are certainly worht considering.

 

[StewartPrince]

Care to explain pal, I would really appreciate it..