Sending Email using Outlook

[Catalina]

Using Access & Outlook 2010.

This works:

Set objOutlookRecip = .Recipients.Add("myemail@gmail.com")

This doesn't. Outlook throws an error saying it does not recognise it.

Set objOutlookRecip = .Recipients.Add("myemail@gmail.com; youremail@gmail.com")

Any suggestions how to solve this.

Thanks.

 

[AccessMSSQL]

I think you have to add each recipient separately.

Set objOutlookRecip = .Recipients.Add("myemail@gmail.com")
Set objOutlookRecip = .Recipients.Add("youremail@gmail.com")

 

[Catalina]

Yes, that's how it works.

Thanks AccessMSSQL

Catalina

 

[Strike_Eagle]

Is there a way to make it auto send given a specific time each day?