Need Help With Email Command

[jerryh]

I am new to Access and Visual Basic and would appreciate any help, so if anyone can point me to some good reference material for beginners I'd appreciate it. I see a lot of great ideas on here regarding what Access can do, but looking at the code is like trying to read Greek for me, so I wasn't sure if there was some kind of reference material out there that shows me what the code means and when I do a copy and paste, what fields I have to update...

So onto my idea that I'd like to implement.

I have a form I'd like to Email. The form has several fields I'd like to include in the body of the message. The intent is to send out the information to a manager, review the data, and make any necessary markups/corrections/comments and send back for me to easily correct in the database. I tried using the "Create Email" function; however, seeing how some fields contain formulas, this function does not pick up those fields. Maybe I should I consider using InfoPath for this function?

Some info on the system I'm using:
Office 2010, Includes Word, Excel, Power Point, Access, Outlook, Publisher, InfoPath, and SharePoint.

[rpeare]

is it your intent to read the email and manually update the changes, or to have access read the return email and make the changes by itself. Is there a reason you can't just send an email reminder to the manager to review the item and have them update it directly? rather than a 2 step process (doubles your chances for errors). I am guessing based on your post that it's going to be a manual process on your end, if that's the case I would send them a word document (exported report) let them do their edits then send the document back to you. When you export a report the values of all calculated fields are preserved which seems to be an issue for you.