Multiple email reciepients for the same file.

[Pip]

Good morning everyone.

I have a macro that emails out a file at the end but I'm having trouble with the syntax for adding another email address to the argument1 line:

arg1:="ask@mrexcel.com", _
arg2:="Daily Report"

How would I add say, "someoneelse@mrexcel.com" in the same line?

Thanks in advance.

 

[lenze]

The macro I use uses a semi-colon as the address separator.

 

[Jay Petrulis]

Could you list the names in an array and use the array as the .SendMail part?

NameList = Array("johnq@public.com", "jane@doe.com")

and then
.SendMail Array(NameList)

Untested in full, but it may work.

Bye,
Hay