Send Email to Multiple Recipients

[Christineeve]

I have this code in production and it's working fine. Except, I send out so many emails that I'm starting to crash out of my applicaton because my email box is full. One reason is that I have this code:

DoCmd.SendObject , "", "", "Kjones@blahblah.com ", " SandyooU812@hotmail.com", , "memememe@hotmail.com", myTableFileName & " is created!", , False

What this is doing is first sending the email to Kjones, then a copy to Sandy, then a blind copy to memememe. I would like it to send all three emails on the To line only. Not on the CC or BCC line.

How do I separate the emails within the To portion of the send code? I tried semi colon that doesn't work.

 

[PHV]

I tried semi colon that doesn't work
Really ?
The VBA help says to use the list separator characacter defined in the regional settings.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Christineeve]

Hi,
I guess it helped just to ask the question. Here is what I did and it worked.

 DoCmd.SendObject , "", "", "Kjones@blahblah.com , SandyooU812@hotmail.com, memememe@hotmail.com", , , myTableFileName & " is created!", , False

Where I put comma's not semi colons between each email.

 

[Christineeve]

Yes, really. I broke the code in the middle. Comma's worked. I thought I tried that before I guess not.

 

[Christineeve]

I went back and checked my help again, and I see that you are correct about the semi colons.

Comma is also working(?). However, I'm wondering why the first time I tried this the semi colon did not work.

But, at least I have it resolved. I'm no longer sending out three different notification emails for each process--only one.

Thanks you for all your help. I can always count on you!