Sending Email with Outlook Using Hidden Addresses

  • Thread starter Thread starter Cameron
  • Start date Start date
C

Cameron

Hi,

I currently have a module which allows me to send emails
to contacts within my database. However, my concern is
that the database could potentially have upwards of 400
contacts which will make for a very ugly "To" line and it
would mean the recipients would have access to the
addresses of all the other recipients. I am wondering if
there is a way to either hide the addresses, or generate
a mailing list containing all the addresses dynamically
so the "To" line only contains the name of the mailing
group.

Thanks in advance,
Cameron
 
It is also possible to create distribution lists in Outlook from Access. It's not perfect, because it pops the OL security warning and fails if OL is not already open. You can trap for the latter. To get around the former (if you care), you may be able to use Redemption or CDO, but I'm not sure. Also, the DL only has the recipient's email, and not their name. That could probably be changed if you were referring to an actual OL contactitem. Finally, you need to set a reference to the OL library

Sub createDL(
Dim ola As Outlook.Applicatio
Dim dli As Outlook.DistListIte
Dim myTempItem As Outlook.MailIte
Dim myRecipients As Outlook.Recipient
Dim qryResults As Objec

Set ola = CreateObject("Outlook.Application"
Set dli = ola.CreateItem(olDistributionListItem
Set myTempItem = ola.CreateItem(olMailItem
Set myRecipients = myTempItem.Recipient
Set qryResults = CurrentDb.OpenRecordset("myquery"
If qryResults.BOF Then GoTo exit_createD
qryResults.MoveFirs
D
myRecipients.Add qryResults!emai
qryResults.MoveNex
Loop Until qryResults.EO
dli.AddMembers myRecipient
dli.DLName = "list1

dli.Close olSav
myTempItem.Close olDiscar
exit_createDL
Set myTempItem = Nothin
Set myRecipients = Nothin
Set dli = Nothin
Set ola = Nothin
qryResults.Clos
Set qryResults = Nothin
End Su

Hope this helps

- Scot
 
Hi Tim, I realize I can use the bcc field, but is the
field large enough to support upwards of 400 email
addresses.

Thanks,
Cameron
 
Hi Tim, I realize I can use the bcc field, but is the
field large enough to support upwards of 400 email
addresses.
Click to expand...

Oh dear: I do try to stay away from anything that has Outlook and Database
in the same message... Have you thought of simply biting the bullet and
getting a decent mail server to handle this sort of stuff properly? If you
can't afford something like Mercury 32, then you can't afford nothing.

B Wishes


Tim F
 
Back
Top