Embedding E-mail w/ Pre-Populated Access Form

[aje35]

I have VBA code that I have developed, with help from MrExcel, that goes through my database and sends an email to each client addressing that specific client (Basically a mailing list). This code is using "db.OpenRecordset" to access the Access database info for pulling the e-mail addresses and contact names and such. Then I am building the e-mail using "MyMail." method.

I have a form that I have created in Access that is tied to the very same database. What I need to code in now is a way to insert this form in to the body of the email I am sending out. I also need the form to be populated with the clients specific database info. This way the clients can see what info we have on file and if a correction needs to be made it can be however I am not wasting all my clients time filling out the form from scratch.

I believe then once they update the form with their information their should be a relatively easy way to pull this in as 'External Data' -> 'Manage Replies' from Outlook to Access.

So just to summarize there are three parts to this project:

1) Embedding Access form in e-mail.
2) Pre-populating this form with specific client info.
3) Updating the database with the new data received back in Outlook.

If there is any additional information I can provide please let me know.

Thanks very much,

AJ

 

[PatrickWW]

Bump This is exactly what I need.