Question Data Collection Via email - Multiple tables

[finndy80]

I am trying to use the data collection wizard in Access because I don't know VBA or what every its called.

I want to update info on some employees of the subcontractors we employ. The information is taken from two tables so I have built a select query as the Access Help says I should, however, the wizard will not allow me to choose the update existing information option.

Therefore, when the email arrives it is blank and makes no reference to the employee that I want the details of, if that makes sense.

I have no idea what to do now and even the Microsoft website page on this doesn't display anymore???

 

[boblarson]

You are using Access 2007 AND Outlook 2007?

 

[finndy80]

Yes, they are both 2007. I have also tried to do this with a make table query and then used the new table, still doesn't work!!

 

[nickblitz]

You are using Access 2007 AND Outlook 2007?

any solution to this? i have been trying to do the same thing....