?
Solved

Help send BCC from excel using VBA

Posted on 2009-04-15
5
Medium Priority
?
1,034 Views
Last Modified: 2013-12-17
I can send a workbook to multiple recipients using the following
Workbooks("Sendemail.xls").SendMail Recipients:="terry@austind.com.au";"gcs@austind.com.au"

How do I add other addresses as BCC
0
Comment
Question by:scarab66
  • 3
  • 2
5 Comments
 
LVL 93

Expert Comment

by:Patrick Matthews
ID: 24153506
Hello scarab66,

You cannot send as a BCC using SendMail, but you can automate Outlook...

Dim olApp As Object
Dim olMsg As Object

Set olApp = CreateObject("Outlook.Application")
Set olMsg = olApp.CreateItem(0)
With olMsg
    .To = "X@z.com"
    .CC = "y@z.com"
    .BCC = "z@z.com"
    .Subject = "subject"
    .Body = "body"
    .Attachments.Add Workbooks("Sendemail.xls").Path & "\Sendemail.xls"
    .Send
End With

Set olMsg = Nothing
Set olApp = Nothing

Using that method may trigger an Outlook security measure implemened starting in Outlook 2000 SP2, and persisting
at least through 2002 and 2003.

To disable it, I've used three products:

1) Express ClickYes
http://www.contextmagic.com/express-clickyes/
There is a free version and a Pro version for ~$30 with more features.  I've used the pro version.
It works as advertised.  I'm not using it currently.  I'm using the MAPILab product instead.

2) MAPILab Advanced Outlook Security
http://www.mapilab.com/outlook/security/
A free COM add-in for Outlook.  I am using it now and I like it

3) Redemption
http://www.dimastr.com/redemption/
A DLL you can use in your code to disable the warnings.  Free download, but you must pay a
license to distribute.  I've used it and like it.


Regards,

Patrick
0
 

Author Comment

by:scarab66
ID: 24153563
G'day Patrick
Can I use Outlook Express or even better Thunderbird
0
 

Author Comment

by:scarab66
ID: 24153720
Patrick
What is wrong with the followind
.Attachments.Add Workbooks("Sendemail.xls").Path & "E:\AA Daily Calcs\Test\Sendemail.xls"

Open in new window

0
 
LVL 93

Accepted Solution

by:
Patrick Matthews earned 2000 total points
ID: 24153725
.Attachments.Add "E:\AA Daily Calcs\Test\Sendemail.xls"
0
 

Author Closing Comment

by:scarab66
ID: 31570768
Thanks Patrick
0

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Here in this article, you will get a step by step guidance on how to restore an Exchange database to a recovery database. Get a brief on Recovery Database and how it can be used to restore Exchange database in this section!
There can be many situations demanding the conversion of Outlook OST files to PST format and as such, there is no shortage of automated tools to perform this conversion. However, what makes Stellar OST to PST converter stand above the rest? Let us e…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Suggested Courses

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question