Multiple email reciepients for the same file.

Pip · May 10th, 2002, 09:18 AM

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 · May 10th, 2002, 03:48 PM

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

Jay Petrulis · May 10th, 2002, 04:10 PM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 10th, 2002, 09:18 AM	#1
Pip New Member Join Date: May 2002 Posts: 1	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.

May 10th, 2002, 03:48 PM	#2
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 13,690	The macro I use uses a semi-colon as the address separator.

May 10th, 2002, 04:10 PM	#3
Jay Petrulis MrExcel MVP Join Date: Mar 2002 Location: Chicago, IL USA Posts: 2,042	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