Use Bcc

[alvin Kuiper]

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 "(e-mail address removed)"
Application.DisplayAlerts = False
ActiveWorkbook.SendMail Recipients:="(e-mail address removed)", _
Subject:=strSubject


On Error GoTo 0
.Close SaveChanges:=False
End With

Alvin

 

[royUK]

Ron de Bruin has a vast amount of email code here:

'Example Code for sending mail from Excel'
(http://www.rondebruin.nl/sendmail.htm)

 

[alvin Kuiper]

Hi
I use one off Ron's scripts
but can't find out sending to a bcc adress

Alvin


"royUK" skrev:

 

[Ron de Bruin]

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