e-mail

[leungkong]

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.

 

[Tom Ogilvy]

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

 

[leungkong]

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

but the cell cannot input - "(e-mail address removed); (e-mail address removed)"

 

[Ron de Bruin]

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

 

[Ron de Bruin]

Good to see you back Tom

Ron

 

[leungkong]

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 = "(e-mail address removed);[email protected]"
Or you can use a mail address in a cell like this
.To = ThisWorkbook.Sheets("Sheet1").Range("C1").Value

 

[Ron de Bruin]

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

 

[Doug Glancy]

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