NEED HELP - Creating an access form for email distribution and input

[losdevil]

Good morning all,


I need help creating an Access form with information and input boxes to distribute via email, then capture the data back in the database. Everyone receiving the email is using MS Exchange and Outlook 2010. I've created a form as you can see in Bad Email, this is what Access generates for my email distribution. The Good Email is the format I'd like Access to create and distribute for me. I usually do not use Access but I can pick it up quite fast. Also, requesting inputs via Sharepoint, a shared database or attachment is out of the question. These guys are often too lazy to even read the emails. All the help and guidance is greatly appreciated. Thank you in advance! BAD EMAIL GOOD EMAIL

[ranman256]

Have a list of names/emails
vb code will shcroll thru the list and send the query that pulls THAT person's data.

  'cycle thru all emps to print
Dim i As Integer
For i = 0 To cboEmp.ListCount - 1
      'get the next person
   cboEmp= cboEmp.ItemData(i)

      'send the email
   DoCmd.SendObject acSendQuery, "qsQuery", acFormatXLS, cboEmp, , , "Subject", "message"
Next

[losdevil]

I really appreciate your time but perhaps I was not able to describe my issue clearly. I'm not looking to automate the data, I'm looking for Access to create a form I may email for the project manager's input once they receive it. I would like to embed somehow, the access data within the email for input and return back to me. Thank you again.

[NTC]

Based on your description you would need to use the Microsoft InfoPath product. What you describe is not possible within Access alone - but Access can be the database for the InfoPath.

[losdevil]

Based on your description you would need to use the Microsoft InfoPath product. What you describe is not possible within Access alone - but Access can be the database for the InfoPath.

Agreed. The formatting is killing me. Thank you for your help.