Avatar of Kevin Smith
Kevin SmithFlag for United States of America asked on

How to use SendObject to send to multiple emails but not cc (put in several emails at once...)...?

I have a simple form in an Access db that lets the user put in an email address and then the body in a form, then the send event fires off an email using the SendObject command (using Outlook).

What if the user wanted to be able to put in several emails in a field (comma separated) and hit send, but it would open the Outlook new email for each email, not CC.

So if they put billy@here.com, tommy@there.com, and jane@buster.com, fill in their body and hit send, three emails would open up (for approval), each to the emails listed above.

How do I do this?

Thanks!
Microsoft AccessVisual Basic Classic

Avatar of undefined
Last Comment
Jim Dettman (EE MVE)

8/22/2022 - Mon
ASKER
Kevin Smith

The emails can have different fields if need be...
ASKER CERTIFIED SOLUTION
Jim Dettman (EE MVE)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
Kevin Smith

nothing happens with option 2...is there any prep to using it?
ASKER
Kevin Smith

How do I call sendobject multiple times?  I've tried simply putting another sendobject command under the other but it doesn't work...still only opens one.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
ASKER
Kevin Smith

Wait, the multiple so opens the emails right after each other...any way possible to get them to all open at once?
Jim Dettman (EE MVE)

<<Wait, the multiple so opens the emails right after each other...any way possible to get them to all open at once? >>

 Yes, I would think so (have never tried it), but I also think your asking for trouble.  If you sent to 100 people, you'd end up with 100 mail items.

 An alternative approach might be to create each of the mail items, save them to the draft older, then display Outlook and the first item from the folder.

  Personally I'd adress the e-mail to myself in the 'to' and then BCC everyone on the e-mail and deal with one mail item object only.

  But that assumes it's the same e-mail for every receipent.
Jim.