How can I make a Yes/No column to select email addresses to add to a new message?

[Raven7738]

Hey,

I'm currently using Access 2007. I've created a form that shows a list of search results in a subform. I want the user to be able to select specific people from the list and press a button to input all the selected addresses into the "To..." box in a new outlook email.

The database has email addresses in a column already. I was curious if it was possible to create an new "yes/no" column and have it equal the value of the email field in the same record if selected. Also how would I manage to connect that to a button to send those values to a new message.

I am also opern to other ideas to how I can do this.

Please let me know if this isn't clear or more information is needed. Thanks in advance!

[thelonelyghost]

Could you share some more information, such as what Operating System you use? What version of Outlook do you wish to use this with?

You could create another column where there are checkboxes, then set a filter to say "where [checkbox]". The tricky part would be to concatenate all fields in the filtered table into one string, separating each email by a semicolon. If you accomplish that, it's just a simple method of inserting that into a mailto: link that is clickable, which then opens a new message in outlook.

My plan doesn't contain much detail, but it gets you started. Your part is to research how to set filters (and possibly make it into a button), creating a form for simple user interface, and what the syntax of mailto: is. Pretty simple compared to the power Access is capable of.

EDIT: After looking at your user information, I'd assume you're doing this for a university club or the like, which makes me happy to say that you can easily make a similar button to the filter of everyone checked, but with a mailing groups. Create a field for groups such as 'Officers', 'Members', etc. and have buttons that email each group. VERY slight change to the coding.

[Raven7738]

Could you share some more information, such as what Operating System you use; what version of Outlook you wish to use this with.

I am currently using Windows XP Professional OS and Outlook 2007

[thelonelyghost]

Service pack 0, 1, 2, or 3? (service pack 0 would not say 'Service Pack' at all)

See my above edits.

[Raven7738]

I looked into the mailto: syntax and came up with SendObject function in macro. I am currently researching the set filters you mentioned, but is there a code that may allow me to take those filters and put it into a macro argument such as the "To" argument in SendObject?

From there I can just have the macro run to edit message

[thelonelyghost]

unfortunately I've only dabbled in the mailto: syntax so you've already looked farther ahead than I have. I was simply thinking about constructing a URL with a LOT of concatenation of email addresses in the mailto: syntax. Maybe one of the experts will come an help...

[Raven7738]

unfortunately I've only dabbled in the mailto: syntax so you've already looked farther ahead than I have. I was simply thinking about constructing a URL with a LOT of concatenation of email addresses in the mailto: syntax. Maybe one of the experts will come an help...

Thank you for your help

[thelonelyghost]

Thank you for your help

No problem, glad I could help!