Multiple E-mails from an Access 2002 Table

  Air_Man 17:07 07 Feb 2004

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.

Elsewhere on IDG sites

AMD Radeon Adrenalin release date, new features, compatible graphics cards

Print designer Kelly Anna on confident mark making & modern femininity

New iMac Pro release date, UK price & specs rumours

Comment créer, utiliser et supprimer son compte Facebook ?