BCC Email using a Command Button
I have a command button in my workbook that will automatically email the file
to some designated recipients. How can I make the email Blind Copy 2 of the recipients? Currently every recipient shows up in the "TO" section. Please Advise, Thanks, Travis |
BCC Email using a Command Button
If you use Outlook see the Outlook object examples on my site
http://www.rondebruin.nl/sendmail.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Tdahlman" wrote in message ... I have a command button in my workbook that will automatically email the file to some designated recipients. How can I make the email Blind Copy 2 of the recipients? Currently every recipient shows up in the "TO" section. Please Advise, Thanks, Travis |
BCC Email using a Command Button
I don't fully understand all that.
Here is the code that I'm using right now. DealerEmail = Sheets("Sample Chair").Range("D14").Value JobName = Sheets("Sample Chair").Range("D17").Value ActiveWorkbook.SendMail Array(RSM_Email, DealerEmail, ", ", ), "Sample Chair - " & JobName End Sub This works perfect for sending it to everyone that I need. But what I would like if I can is to make it so that Person2 and Person3 are blind copied instead. Do you know how I can alter the code that I already have? Thanks, Travis "Ron de Bruin" wrote: If you use Outlook see the Outlook object examples on my site http://www.rondebruin.nl/sendmail.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Tdahlman" wrote in message ... I have a command button in my workbook that will automatically email the file to some designated recipients. How can I make the email Blind Copy 2 of the recipients? Currently every recipient shows up in the "TO" section. Please Advise, Thanks, Travis |
BCC Email using a Command Button
With SendMail it is not possible
Use the Outlook object model examples on my site For example this one http://www.rondebruin.nl/mail/folder2/mail1.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Tdahlman" wrote in message ... I don't fully understand all that. Here is the code that I'm using right now. DealerEmail = Sheets("Sample Chair").Range("D14").Value JobName = Sheets("Sample Chair").Range("D17").Value ActiveWorkbook.SendMail Array(RSM_Email, DealerEmail, ", ", ), "Sample Chair - " & JobName End Sub This works perfect for sending it to everyone that I need. But what I would like if I can is to make it so that Person2 and Person3 are blind copied instead. Do you know how I can alter the code that I already have? Thanks, Travis "Ron de Bruin" wrote: If you use Outlook see the Outlook object examples on my site http://www.rondebruin.nl/sendmail.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Tdahlman" wrote in message ... I have a command button in my workbook that will automatically email the file to some designated recipients. How can I make the email Blind Copy 2 of the recipients? Currently every recipient shows up in the "TO" section. Please Advise, Thanks, Travis |
All times are GMT +1. The time now is 12:09 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com