e-mail
 

i am using "sendmail" to send out the workbook as below
e.g. workbook.SendMail emailaddr, subject

The email address is come from a contact list.
The problem is I can send to one email address only.

Any suggestion? Thanks.

e-mail
 

workbook.Sendmail array(emailaddr1, emailaddr2, emailaddr3), subject

--
Regards,
Tom Ogilvy


"leungkong" wrote:

i am using "sendmail" to send out the workbook as below
e.g. workbook.SendMail emailaddr, subject

The email address is come from a contact list.
The problem is I can send to one email address only.

Any suggestion? Thanks.

e-mail
 

Thanks Tom,
But emailaddr is come from a contact list.
useing a code to search the address.
e.g.
Code Address
ABC

but the cell cannot input - ; "


"Tom Ogilvy" wrote:

workbook.Sendmail array(emailaddr1, emailaddr2, emailaddr3), subject

--
Regards,
Tom Ogilvy


"leungkong" wrote:

i am using "sendmail" to send out the workbook as below
e.g. workbook.SendMail emailaddr, subject

The email address is come from a contact list.
The problem is I can send to one email address only.

Any suggestion? Thanks.

e-mail
 

See two other ways on this page
http://www.rondebruin.nl/mail/tips1.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"leungkong" wrote in message ...
Thanks Tom,
But emailaddr is come from a contact list.
useing a code to search the address.
e.g.
Code Address
ABC

but the cell cannot input - ; "


"Tom Ogilvy" wrote:

workbook.Sendmail array(emailaddr1, emailaddr2, emailaddr3), subject

--
Regards,
Tom Ogilvy


"leungkong" wrote:

i am using "sendmail" to send out the workbook as below
e.g. workbook.SendMail emailaddr, subject

The email address is come from a contact list.
The problem is I can send to one email address only.

Any suggestion? Thanks.

e-mail
 

Good to see you back Tom

Ron


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Tom Ogilvy" wrote in message ...
workbook.Sendmail array(emailaddr1, emailaddr2, emailaddr3), subject

--
Regards,
Tom Ogilvy


"leungkong" wrote:

i am using "sendmail" to send out the workbook as below
e.g. workbook.SendMail emailaddr, subject

The email address is come from a contact list.
The problem is I can send to one email address only.

Any suggestion? Thanks.

e-mail
 

Thanks Ron de Bruin,
I read the website as below. I input two address in cell, using " ; " to
separate two address. But I've got the error 424.


You can use this to send to more then one person.
.To = "
Or you can use a mail address in a cell like this
.To = ThisWorkbook.Sheets("Sheet1").Range("C1").Value

"Ron de Bruin" wrote:

See two other ways on this page
http://www.rondebruin.nl/mail/tips1.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"leungkong" wrote in message ...
Thanks Tom,
But emailaddr is come from a contact list.
useing a code to search the address.
e.g.
Code Address
ABC

but the cell cannot input - ; "


"Tom Ogilvy" wrote:

workbook.Sendmail array(emailaddr1, emailaddr2, emailaddr3), subject

--
Regards,
Tom Ogilvy


"leungkong" wrote:

i am using "sendmail" to send out the workbook as below
e.g. workbook.SendMail emailaddr, subject

The email address is come from a contact list.
The problem is I can send to one email address only.

Any suggestion? Thanks.

e-mail
 

You are looking at the example page to change the outlook object model examples from my site

See
http://www.rondebruin.nl/mail/tips1.htm



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"leungkong" wrote in message ...
Thanks Ron de Bruin,
I read the website as below. I input two address in cell, using " ; " to
separate two address. But I've got the error 424.


You can use this to send to more then one person.
.To = "
Or you can use a mail address in a cell like this
.To = ThisWorkbook.Sheets("Sheet1").Range("C1").Value

"Ron de Bruin" wrote:

See two other ways on this page
http://www.rondebruin.nl/mail/tips1.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"leungkong" wrote in message ...
Thanks Tom,
But emailaddr is come from a contact list.
useing a code to search the address.
e.g.
Code Address
ABC

but the cell cannot input - ; "


"Tom Ogilvy" wrote:

workbook.Sendmail array(emailaddr1, emailaddr2, emailaddr3), subject

--
Regards,
Tom Ogilvy


"leungkong" wrote:

i am using "sendmail" to send out the workbook as below
e.g. workbook.SendMail emailaddr, subject

The email address is come from a contact list.
The problem is I can send to one email address only.

Any suggestion? Thanks.

e-mail
 

I second that. Don't really know who you are Tom, except a great resource
to this group. A while ago I noticed that that I wasn't seeing your name
here lately. This morning when I saw you answering questions, it brought a
smile to my face.

Doug

"Ron de Bruin" wrote in message
...
Good to see you back Tom

Ron


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Tom Ogilvy" wrote in message
...
workbook.Sendmail array(emailaddr1, emailaddr2, emailaddr3), subject

--
Regards,
Tom Ogilvy


"leungkong" wrote:

i am using "sendmail" to send out the workbook as below
e.g. workbook.SendMail emailaddr, subject

The email address is come from a contact list.
The problem is I can send to one email address only.

Any suggestion? Thanks.