Email distribution list members separately

[mdmackillop]

For reasons of confidentiality, we have to send separate emails to each tenderer on a list (Maximum 6-8 recipients). I'd like to be able to use an distribution list, but I need to send to each, with no details of any of the other recipients. Can this be done without code, or do I need a bit of VBA?
Regards
MD

[mvidas]

To parse the list I think you'd have to use VBA, but why not do something like

From: MD
To: MD
BCC: DistributionList

The recipients wouldn't know of each other, only see your name in the From and To, and you wouldn't have to use a macro or anything

[mdmackillop]

Hi Matt,
The emails have to be addressed to each recipient, which I doesn't happen with BCC

[mvidas]

I understand.. unless you want to do it manually, I don't think theres a way without using VBA

To see how it would be done, this writes an email to everyone in a list named "Cards":Sub MDMDistribute()
Dim DList As DistListItem, i As Long
Set DList = Application.Session.GetDefaultFolder(olFolderContacts).Items("Cards")
For i = 1 To DList.MemberCount
With Application.CreateItem(olMailItem)
.To = DList.GetMember(i)
.Subject = "September Mailing"
.Body = "Hi"
.Display
'.Send
End With
Next
End Sub

[mdmackillop]

Thanks Matt,
I'll give it a try tomorrow.