By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,473 Members | 3,234 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,473 IT Pros & Developers. It's quick & easy.

Email Data Collection - Can I autopopulate a field based on the email address?

P: 6
I would like to set-up an email data collection to gather volunteer hours from our volunteers. Is there a way to auto-populate a field if I use the HTML format. Each volunteer has a Contact ID, but they don't know what it is. Can just replying to the email populate that field since their email address is linked to their Contact ID?
Feb 8 '08 #1
Share this Question
Share on Google+
2 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
Sorry but I am not clear from your question exactly what you are asking. Can you please provide more detailed information about what you are trying to do.
Feb 10 '08 #2

P: 6
I have two volunteer tables. One is tblVolunteer and the other is tblHours. tblVolunteer includes the following fields [ContactID] and [email]. tblHours includes multiple entries for each ContactID that includes their task and the number of hours with the following fields [ContactID], [Task], [Hours]. The ContactID is a concatenated field - a combination of their last name and first, but the volunteer doesn't know what it is and I don't want them to have to enter it on the form (too much room for errors). Since their email address is linked to their ContactID, and the email form is obviously being sent to their email, I wonder if there is a way to autopopulate the ContactID field in the tblHours when they respond to the email. In essence I need to capture their ContactID information in the response without them having to manually enter it. Any suggestions?
Feb 11 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.