Access to Outlook and Hiding the 'To:' Field from Readers 1

[JPeters]

Hey guys,

I've got the Outlook 8.0 object library referenced up in my email database. Outlook's standard new mail form is being used. The database populates the recipient field in the email that is being sent based on what group of people(s) the user decides to send to. One email could be sent to anywhere from 1 to 8000 people using this database.
I have a problem though, I dont want the recipient to be able to see who the email was sent to. I don't like the idea of every single one of our customer's having the potential to know every email adress in our database.
I've tried creating my own forms in access and hidin the To: and CC: fields then saving them as Outlook Templates, but I can't get Access to open up these templates instead of a standard Outlook New Mail Form. Is there a way to make the To and Cc fields hidden to the reader from within the VBA module using the Outlook object library? I've spent awhile browsing it and haven't found much.
Or is there a way to populate an email list (one email address that constitutes 'x' number of recipients) instantaneously based on my choices in the database... so that all the user see's is ForYourEyesOnly@mycompany.com? Does a program like this exist? Thanks in advance. -Happen609
These things take time...

 

[RickSpr]

You can't hide the To and CC fields, but you don't have to. Just leave them blank, and use the BCC field (the MailItem object's BCC property). A lot of people don't even know it exists, because it's not shown in the new message form by default. To see it in an email window, choose View|Bcc Field from the menu.

The BCC field isn't sent as part of the message, so recipients won't see each other's email addresses. Rick Sprague

 

[JPeters]

Rick,
Once again you manage to come through for me. I can't express how much we all appreciate you here.
-Happen609
These things take time...