Results 1 to 6 of 6
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    austin, Texas, USA
    Posts
    1,029
    Thanks
    0
    Thanked 0 Times in 0 Posts

    'Serial' E-mailing to a D-list (Win2KPro, OL2K SR-1)

    We maintain several d-lists, some with many many names and I was wondering if there's a way to send each person an e-mail serially, rather than as a member of a d-list group. One reason for wanting to do this is to prevent a cloud of other e-mailed people's names in the header of the e-mail when printing and another would be to make it a little easier to parse bounce-back messages to the actual offending e-mail addy.

    I'd like a solution that I can code for myself rather than a 3rd party tool.

    TIA

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: 'Serial' E-mailing to a D-list (Win2KPro, OL2K SR-1)

    You can either put all of the DL into the BCC field, which leaves all other recipients unknown to each recipient and does not print them, or I believe you can you can mail merge to e-mail using the DL.
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    austin, Texas, USA
    Posts
    1,029
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'Serial' E-mailing to a D-list (Win2KPro, OL2K SR-1)

    I tried the BCC approach -- put the DList in the BCC box -- and the problem with that is you still have to have someone in the "To" part so people may see it is to someone not themselves and delete/ignore the e-mail.

    How, then, do you mail merge to new Outlook e-mails containing the same content (a template?) from the Dlist?

  4. #4
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: 'Serial' E-mailing to a D-list (Win2KPro, OL2K SR-1)

    <P ID="edit" class=small>(Edited by JohnBF on 17-Dec-03 17:21. Code corrected)</P>Steve, it appears you have me on a couple of things! <img src=/S/grin.gif border=0 alt=grin width=15 height=15> On using BCC, I'd include the sender in the TO; line. But I can't find a way to merge to a DistList. Here is some starter code:

    Public Function GetCurrentItem() As Object
    On Error Resume Next
    If TypeName(Application.ActiveWindow) = "Explorer" Then
    Set GetCurrentItem = ActiveExplorer.Selection(1)
    Else
    Set GetCurrentItem = ActiveInspector.CurrentItem
    End If
    End Function

    Sub MessageToEachInDistList()
    Dim OlApp As Application
    Dim intC As Integer
    Dim dlList As DistListItem
    Dim msg As MailItem

    On Error Resume Next
    Set dlList = GetCurrentItem

    If Not dlList Is Nothing Then
    Set OlApp = CreateObject("Outlook.Application")
    For intC = 1 To dlList.MemberCount
    Set msg = OlApp.CreateItem(olMailItem)
    With msg
    <font color=red>' Many thanks to Jefferson for the correction, pointing out that in the original code
    ' 'GetMember' was 'With' the wrong object!</font color=red>
    .To = dlList.GetMember(intC).Address
    .Subject = "Test"
    .Body = "Text"
    .Save
    ' .Send ' disabled for testing
    End With
    Next intC
    Else
    MsgBox "Selected item is not a Distribution List"
    End If

    Set msg = Nothing
    Set dlList = Nothing
    Set OlApp = Nothing
    End Sub
    -John ... I float in liquid gardens
    UTC -7ąDS

  5. #5
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    austin, Texas, USA
    Posts
    1,029
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'Serial' E-mailing to a D-list (Win2KPro, OL2K SR-1)

    Hmmm...this kinda works. I'll need to run the code on an existing e-mail rather than use code to send an e-mail from scratch. Ideally, create an e-mail as usual, select the d-list one wants to e-mail serially then run the macro. Once that's done, distribute the code to thems that needs it.

    Time to dig into the OL object model!

    Thanks all for the help. <img src=/S/duck.gif border=0 alt=duck width=23 height=23>

  6. #6
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    austin, Texas, USA
    Posts
    1,029
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'Serial' E-mailing to a D-list (Win2KPro, OL2K SR-1)

    PROBLEM SOLVED (with no coding!)

    The basic need here was to send an e-mail out to a DList in such a way that the recipients don't have a huge list of everyone else's names on the header section of the printed e-mail.

    RESOLUTION:
    Follow the guidlines on KB266339 http://support.microsoft.com/?kbid=266339
    The solution is very simple:
    1) Create your DList as usual
    2) Create a new contact item with a suitable name for the 'To' (such as the D-List name, etc. -- something that will make sense to each recipient)
    3) Assign an e-mail to this contact -- the e-mail CANNOT be one listed in the Global Address book
    4) In the E-mail properties box, assign the Display name for this e-mail address the same name as the Contact itself
    5) Compose your e-mail, assign the 'To' field to your just-created contact and place the DList in the BCC field

    Viola! Your d-list people get a notice from you to the generic name of the just created contact and none of the other names are listed in the recieved e-mail. Presumably, people in the D-List are not going to be baffled that you've sent them something...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •