Multiple E-mails from an Access 2002 Table

  Air_Man 17:07 07 Feb 04

I have a database that identifies relevant sales reps based on a county and division and shows them on the main form. I want to create a button that automatically takes these relevant sales people and creates an e-mail to them with a report I have written. The relevant reps appear on a subform. I would like to use the query from the subform and extract the names and add them to the "TO" part of an e-mail. I can create an e-mail ok, but don't know how to turn a query output into a text string for insertion into the DoCmd SendObject command in VBA.

Any help would be much appreciated.

This thread is now locked and can not be replied to.

Nintendo Switch (Nintendo NX) release date, price, specs and preview trailer: Switch price…

1995-2015: How technology has changed the world in 20 years

Best Photoshop video tutorials: 8 video tutorial websites for Photoshop

How to speed up a slow Mac: 19 great tips to make an iMac, MacBook or Mac mini run faster | Speed…