how to send automatic emails to collect data for a table

[mulamootil]

Hi, I have few tables and i am populating them using respective forms. However on one of the tables, there are 10 fields out of which 2 fields, I would like some other user to fill it. Is there a way to notify users by email every time I fill the first 8 fields in the form and the other user completes the rest by email.

I have seen a group called collect data using email in Access, but it just randomly puts the record wherever it wants. Hope I have explained my situation here well.

Thank you all for helping me previously with my requests. Is there a VBA code or something that would fix this problem. I appreciate any help.

Stan

[Echidna]

Hiya,

There is a nice section MS has written about this subject.

http://office.microsoft.com/en-us/ac...154271033.aspx

Hope this helps

Leon

[TheSmileyCoder]

Do you know of any similar source for Access 2003?

[nico5038]

I'm afraid you'll need to write the email response and the processing of the answer yourself....
One way is using the body text, another is to use an (excel) attachment with the record(s).

Nic;o)

[mulamootil]

Thank you so much for your replies. I checked the site mentioned by Leon and it does not show me a way where I can send emails from a form for records to be updated in a table. The user will have to go to the table every time to go through the wizard to send an email. I really do not understand Nic;o's suggestion....I am very new to access or anything like this. Thanks again.

[beacon]

You will need to write a procedure into your form that checks to see whether or not you have filled in the first 8 fields or not before you send the email. Then you'll need to write a procedure that tells Access to send an email once those 8 fields have been completed.

The link that Leon provided is very detailed and shows you how to go through the 'Collect Data' wizard so that you can create the form that will be send with the email to actually collect the data for the remaining 2 fields. You will link the 2 fields on the form that you create with the 2 fields that are in your database.

Keep in mind that if you aren't using Access 2007 you will have to find an alternative solution. The first solution that Nico mentioned (about body text) essentially requires you to call Outlook or your email client from Access and then fill in the To, CC, Subject, and Body, which can be done using VBA. An example can be found at the following 2 links: http://msdn.microsoft.com/en-us/libr...ffice.11).aspx or http://www.blueclaw-db.com/access_em...nd_outlook.htm.

[mulamootil]

Okay thank you so much. I will try these.