| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use Bcc
Hi
I have this: is there a way to add a bcc adress With Destwb .SaveAs TempFilePath & TempFileName & FileExtStr, _ FileFormat:=FileFormatNum 'On Error Resume Next ' .SendMail " Application.DisplayAlerts = False ActiveWorkbook.SendMail ", _ Subject:=strSubject On Error GoTo 0 .Close SaveChanges:=False End With Alvin |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Use Bcc
Ron de Bruin has a vast amount of email code he 'Example Code for sending mail from Excel' (http://www.rondebruin.nl/sendmail.htm) -- royUK Hope that helps, RoyUK For tips & examples visit my 'web site' (http://www.excel-it.com/) ------------------------------------------------------------------------ royUK's Profile: http://www.thecodecage.com/forumz/member.php?userid=15 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=99804 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Use Bcc
Hi
I use one off Ron's scripts but can't find out sending to a bcc adress Alvin "royUK" skrev: Ron de Bruin has a vast amount of email code he 'Example Code for sending mail from Excel' (http://www.rondebruin.nl/sendmail.htm) -- royUK Hope that helps, RoyUK For tips & examples visit my 'web site' (http://www.excel-it.com/) ------------------------------------------------------------------------ royUK's Profile: http://www.thecodecage.com/forumz/member.php?userid=15 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=99804 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Use Bcc
On top of every SendMail example page you can read this
With SendMail it is not possible to : 1) Send text in the Body of the mail 2) Use the CC or BCC field 3) Attach other files Use the Outlook object model examples from my site -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "alvin Kuiper" wrote in message ... Hi I use one off Ron's scripts but can't find out sending to a bcc adress Alvin "royUK" skrev: Ron de Bruin has a vast amount of email code he 'Example Code for sending mail from Excel' (http://www.rondebruin.nl/sendmail.htm) -- royUK Hope that helps, RoyUK For tips & examples visit my 'web site' (http://www.excel-it.com/) ------------------------------------------------------------------------ royUK's Profile: http://www.thecodecage.com/forumz/member.php?userid=15 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=99804 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
