DoCmd.SendObject

[Carlotta Stephens via AccessMonster.com]

Hello, I?m trying to automate sending multiple emails using the
DoCmd.SendObject. I have a report that groups managers; each manager has a
number of users under them. What I want to do is to get Access to identify
each manager and send an email to them listing their users in an excel
format. Is this possible? If so can anyone help - I?m afraid I know very
little about VB. Many thanks in advance???Carla

 

[[MVP] S.Clark]

Without knowing VBA, you have a large learning curve ahead of you. The gist
would be to build a string of email addresses and pass that as the To
parameter for the sendobject method.