L
lintonneedsyourhelp
I've read through some of the posts on this topic, but I didn't see any
solutions that would work for Access 2007 specifically. I'm not skilled
enough in this area to make one of the similar solutions work ... I'm hoping
someone can post exactly what to do.
What I'm trying to accomplish is very simple and I appreciate any help you
guys can provide--I've tried to describe exactly what I'm trying to build
below as clearly as possible.
I'm trying to make a form that:
1) has a combo box that lets the user select a single record in a query (the
value selected in the combo box will be the subject line of the email message)
2) has another combo fox that lets the user select multiple records on a
table based on one field (company names are selected in the "Company Name"
field in the combo box; the same table has an "Email Address" field that will
be used to send the message)
3) has a button that sends an email message to the addresses in the field
mentioned above; the email message subject line should be the field selected
in the first combo box (the one that pulls from the query)
I've checked out http://www.granite.ab.ca/access/email.htm, but the "Sample
Code .." and the "EmailSenate2K" examples are too different from what I'm
trying to accomplish for my skill level to modify the examples and make it
work.
All help or ideas are greatly appreciated!!!! Not knowing how to do this is
holding up a lot of work for me.
Linton
solutions that would work for Access 2007 specifically. I'm not skilled
enough in this area to make one of the similar solutions work ... I'm hoping
someone can post exactly what to do.
What I'm trying to accomplish is very simple and I appreciate any help you
guys can provide--I've tried to describe exactly what I'm trying to build
below as clearly as possible.
I'm trying to make a form that:
1) has a combo box that lets the user select a single record in a query (the
value selected in the combo box will be the subject line of the email message)
2) has another combo fox that lets the user select multiple records on a
table based on one field (company names are selected in the "Company Name"
field in the combo box; the same table has an "Email Address" field that will
be used to send the message)
3) has a button that sends an email message to the addresses in the field
mentioned above; the email message subject line should be the field selected
in the first combo box (the one that pulls from the query)
I've checked out http://www.granite.ab.ca/access/email.htm, but the "Sample
Code .." and the "EmailSenate2K" examples are too different from what I'm
trying to accomplish for my skill level to modify the examples and make it
work.
All help or ideas are greatly appreciated!!!! Not knowing how to do this is
holding up a lot of work for me.
Linton