DoCmd.SendObject

  • Thread starter Thread starter Carlotta Stephens via AccessMonster.com
  • Start date Start date
C

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
 
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.
 
Back
Top