M
michaelcloss
Hi! I am trying to create a string to enter as the "To" argument for
sendObject in Access 2000. I want to create this string based on
several different query results. I have one table that contains the
email addresses for several different people in different departments
(i.e. Sales, IT, Finance). I would like to use queries to filter out
the seperate departments and create a string (i.e. strSales) that will
include all of the individuals from the query.
To illustrate, I create a parameter query to filter all of the email
addresses I have stored for Sales. The query results would list "John
Doe", "Jane Doe", "Joe Schmoe" as separate records. I need to capture
those separate records as one string that would read "John Doe, Jane
Doe, Joe Schmoe"; let's call this string strSales. This way I could
enter "strSales" into the "To" argument of sendObject.
This solution would work great as the Admin users could just add or
delete persons from the appropriate table rather than change the VBA.
Any ideas?
sendObject in Access 2000. I want to create this string based on
several different query results. I have one table that contains the
email addresses for several different people in different departments
(i.e. Sales, IT, Finance). I would like to use queries to filter out
the seperate departments and create a string (i.e. strSales) that will
include all of the individuals from the query.
To illustrate, I create a parameter query to filter all of the email
addresses I have stored for Sales. The query results would list "John
Doe", "Jane Doe", "Joe Schmoe" as separate records. I need to capture
those separate records as one string that would read "John Doe, Jane
Doe, Joe Schmoe"; let's call this string strSales. This way I could
enter "strSales" into the "To" argument of sendObject.
This solution would work great as the Admin users could just add or
delete persons from the appropriate table rather than change the VBA.
Any ideas?