Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help Generating Emails

Status
Not open for further replies.

Shadez

Programmer
Jul 5, 2001
57
US
Ok fairly new to the actual programming aspect of access. So please try and be user friendly with an answer :) I will probably give useless info here, I think it's better to give to much info then to little.

I have a query set that lets me filter records according to project #. So at the time of running it if I type in 3813 for a project number. I get only members that have interest in that project populating the form.

The Ideal of this code would be to have it take all emails associated with a certain project and place them into the mailto for outlook. Obviously I would rather have it BCC'd but beggers can't be choosers. I am racking my head over this, admittedly mainly due to my lack of knowledge in creating and triggering the code.

So here I am looking at a form that gives me all this useful information. Now I need a way to get the email names into a program that can use them.

Few ways to attempt this and I would love suggestions/solutions to this problems.

1) Open outlook populating it with email names in the mailto field.

2) Put all the email messages into a text delimited list, that is put directly into the clipboard.

Please give a detailed description on how to accomplish either of these tasks. As I sais I am very new to the programming aspect of this but I am very eager to learn.


Thanks in advance
 
See my reply in Access Forms. Hopefully that will at least give you a good idea.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top