Edit MS access to Outlook 2010 data Collection form and resend

[Jerry Maiapu]

Hello everyone,
I have searched the forum and internet on collecting data from outlook into access with custom formatting but no there is no resource to assist.

I 'have looked at the following options:
1. Create custom outlook from and connect to access 2010
2.Create outlook form using access to outlook data collection wizard and modify to suit my needs
3. Create inforpath form and convert to outlook form and connect to access.
And what I decided to use is the HTML outlook 2010 data collection form (survey form) generated by MS access 2010 data collection wizard.
However, the generated format is not quite user friendly especially with multiple choice questions where the options appear at the bottom. To answer such a question the user has to press Ctrl + click on link to access the options that are located at the bottom of the form which is not very user friendly.
So I used an HTML editor to move the options close to where the questions appear so that users do not need to scroll down or click on link every time to see their choices.
Now the problem is that the form is no longer connected to MS access since I have modified the form layout. Maybe the connection is lost somehow.
Can someone assist me to reconnect the modified outlook form to the MS access database table? I have not changed anything, just moved the options of each question close to its corresponding question. This is to make available the option right next to the question for easy response.
I don’t know if this can be achieved by placing a code in the HTML source of the form or thwacking some settings in outlook and MS access but I would appreciate if someone can assist me in reconnecting the outlook form back to the access table so that all responses received will be automatically processed/stored in access table.
I am very new to outlook and access 2010 integration and am stuck now.
PLS HELP!!
Thanks..

[zmbd]

JM:
{The feature is not documented very well; however,}
However, here's a start: automation code:
Application Automation

[zmbd]

Jerry Maiapu:
{As I noted earlier,} the feature is not very well documented.
The HTML form has a very limited template format and it appears that when the email is returned, the html is parsed somehow for a very specific section and if that is altered then the HTML form breaks.
Someone will have to disect the HTML code to see what is happening.

[zmbd]

I really had to do some digging for this information and it read as not for the faint of heart. Also there's not a lot of detail, just enough be a tad frustrating... still it may prove useful.

I've read thru it twice now and I'm still not entirely sure I have it down yet:

Automate data collection forms using VBA

[Jerry Maiapu]

Honestly, I felt out of place after reading the comments but its ok I respect forum members and try to learnt from every posting and comments here so I will take it anyway.

By the way Neo thanks for stepping in with clarifications.

zmbd, thanks for the link, I was at the crossroads but that will point to the right direction.

I will come back if I achieve what am looking for.

[Narender Sagar]

Jerry, You can achieve what you want by using MS Infopath.
Infopath is perfect choice for Data collection or for surveys.
Infopath forms can be send to users via outlook and data will be stored in your Access Database. (And this is what you want)..

[Jerry Maiapu]

Thanks Narender Sagar.
I guess one of the requirements using infopath i.e the end user need to have infopath installed otherwise it won't work. My target group do not have infopath installed at thier end.

[amigentie]

Dear Jerry, have you found a solution to edit your form generated by Access? Do you maybe know where the produced form is generated, what kind of file is it? Is it by any chance a form with the same format as a customisable Outlook form ? I am also trying to change that form (I dont have any programming skills)
Kind Regards