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

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

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

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