Bcc messages from Access 03 to Outlook

  • Thread starter Thread starter Ultraviolet47
  • Start date Start date
U

Ultraviolet47

Hi

I have code that opens up an email based on a query from Access. It
puts it in the To field, but it's a newsletter and needs to go in the
BCC field. I have tried placing BCC in various places, but no luck.

A post on here said to get a Recipient object when adding to the
Recipients collection and set to
Recipient.Type = olBCC and make sure you also have a To address.

Does anyone have an idea on how to set the recepient object and set a
To: address?

I have tried variation of the below, but no luck?
MyMail.Recipients.Add MailList("email")
Dim olookRecipient As Object 'Outlook.Recipient
Set olookRecipient = obEmail.Recipients
Recipient.Type = olBCC

Thanks guys :)
 
You need to use the Recipient object that Recipients.Add returns:

Set objRecip = MyMail.Recipients.Add MailList("email")
objRecip.Type = olBCC

FYI, there is a newsgroup specifically for general Outlook programming issues "down the hall" at microsoft.public.outlook.program_vba or, via web interface, at http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.outlook.program_vba

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
Back
Top