I have a report based on a query that looks perfect.
[Affiliate Name] one person
[Partner] *this could be several people
[ClientName] *this could be several people
When I query, it pulls up ALL of the affiliates. With so many affiliate and reports to email individually, I'd like to have a query/macro/vba whatever to do this a little more automagically (command button) i.e Email Active Affiliate Reports. I have a nice email add-in that will take the email field of my affiliates table and attach a file, so maybe saving each report as [affiliateID]is an option.
[Affiliate Name] one person
[Partner] *this could be several people
[ClientName] *this could be several people
When I query, it pulls up ALL of the affiliates. With so many affiliate and reports to email individually, I'd like to have a query/macro/vba whatever to do this a little more automagically (command button) i.e Email Active Affiliate Reports. I have a nice email add-in that will take the email field of my affiliates table and attach a file, so maybe saving each report as [affiliateID]is an option.
