EMail Macro

[Macker72]

Hi

Could someone please tell me why this does not treat each email address seperately?

Application.Dialogs(xlDialogSendMail).Show "anon@anon.com; anon2@anon2.com", "Stats"

It works when i only use 1 email address.
Thanks
mac

 

[Mudface]

Does the following work OK for you?

Application.Dialogs(xlDialogSendMail).Show Array("anon@anon.com", "anon2@anon2.com"), "Stats"

 

[Macker72]

Yes! Many thanks