vbA

[Andyjones]

i have created a database with help of other to log my clubs sports score by player etc. what I want to do is to create and email form that I can email out so other club captains can send me their scores and info to add to my database.

I do not want to use excel, I just want to know if this is possible using out look to send the email.

1. There are multiple tables that will need updating. Via the email form.

Has anyone created anything like this before can you help. Has anyone created an add in or know of an ms add in for this. Is there vba code that can do this task for me if so would really appreciates someone’s help in figuring this out.

Basicaly the main database entry form i need to create a query or vba code to allow all the fields in that form to be updated via email

[June7]

Investigate the Collect Data functionality in Access. Be warned, this is removed from Access 2013. http://office.microsoft.com/en-us/ac...15427.aspx#BM3
However, I think can only update a single table with this operation.

Otherwise, VBA can extract data from body of emails but the code would be complex and requires the email to be a consistent structure.