Auto Email via xlDialogSendMail addressing question
 

Hi DonC,

Try using the Array function:

Application.Dialogs(xlDialogSendMail).Show
")

Regards,

Jake Marx
MS MVP - Excel


"DonC" wrote in message
...
Hi All,
I'm using xlDialogSendMail in Excel to create a e-mail
with the workbook attached. If I enter 1 e-mail address
in ARG1, it works fine. If I enter multiple addresses,
seperated by a ; and space, Outlook does not recognize the
individual names-it sees the entire string a one name.
Anybody know if this can be done, and how??

BTW Both Excel and Outlook ver 2000 SR1

Thanks in advance,

DonC