Access - Outlook

[Paris1988]

Hi all, this is my first thread at this site and i have tried to find a solution for some time now..



My application is distributed to 15 users and i want the users to be able to email records directly from Access.

My idea is that a set of queries will populate a “e-mail”-form and from there the user should have the option to Send the email, thus also creating a timestamp of this event.
The email body is a “template” were “placeholders” should accommodate selected data. The email will accommodate 2 default attachments and one to be selected by each user..
Ideally the “From” field should include a generic email address related to our “collective email-box”...

What is the best approach?

Thanks!

[June7]

What have you tried?

Access/Outlook interoperability is common topic. Search of forum or Google should offer a lot of references.

Review:
http://forums.aspfree.com/microsoft-...ro-447084.html

[Paris1988]

I have looked at many models but not sure if any actually serves my purposes.

My main issue is to solve the question regarding the “Template”. Not sure how to proceed here..

Should the template be a “record” in Access, should it be a .oft template and in that case how do i activate it..placeholders..

Thanks for your suggestion!

What have you tried?

Access/Outlook interoperability is common topic. Search of forum or Google should offer a lot of references.

Review:
http://forums.aspfree.com/microsoft-...ro-447084.html

I have looked at many models but not sure if any actually serves my purposes.

[June7]

Nothing will serve your purpose perfectly. Have to adapt. I have never used an oft file. The code in referenced link is all I have implemented.