| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert to HTML and e-mail selection as the body of the e-mail. | Excel Programming | |||
| Error: cannot load the mail service. Check your mail installation. | Excel Discussion (Misc queries) | |||
| General mail failure when sending e-mail from Excel | Excel Discussion (Misc queries) | |||
| Creating TWO-WAY E-Mail Attachments with 'BeforeSave Events' in Code for 2nd E-Mail | Excel Programming | |||
Linear Mode
