Results 1 to 8 of 8
  1. #1
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Blacktown, Sydney, New South Wales, Australia
    Posts
    175
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Create new message from Contact (Outlook XP)

    I wish to create a new message for a bunch of contacts using a template form

    I am the editor of a newsletter. I have all the subscribers in a contacts folder called 'Newsletter'. From time to time, I receive new subscribe e-mails. I have a rule which transfers them to a 'subscribers' folder. I add the subscriber to contacts using right click option and add 'Newsletter to the category.
    So far so good.
    The current newsletter is an attachment to a template that I have created along with the appropriate message. I can select the new subscribers by category, and have a button which creates new message from contact. This places the new subscribers in the 'To' box of a new default message.

    What I wish to do, is to add those contacts to the BCC field of my template with the attachment. Have not been able to figure this out, except to cut the addressees from the default message, open a new template form, and paste the addresses into the BCC field. This is particularly nasty when a new issue is sent out with nearly 500 recipients.

    There just gotta be an easier way.

  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: Create new message from Contact (Outlook XP)

    Tools | Mail Merge | Merge to e-mail will send a separate message to each recipient, though they will be "To:" not "BCC:". Search this Forum for more on using Outlook Mail Merge.
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Blacktown, Sydney, New South Wales, Australia
    Posts
    175
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Create new message from Contact (Outlook XP)

    Thanks John,
    but I think that this would create 500 e-mails ALL with an attachment. I would blow my monthly ISP allowance in one fowl swoop. Can anyone sugest how I might do this with code?

  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: Create new message from Contact (Outlook XP)

    Devious, I would think sending one message to 500 BCC: recipients would use the same 'capacity' as 500 separate TO: messages. You might want to ask your ISP about it. I also think that perhaps you should send your e-newsletter in the body of the message rather than as an attachment, if capacity limit is an issue.
    -John ... I float in liquid gardens
    UTC -7ąDS

  5. #5
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Blacktown, Sydney, New South Wales, Australia
    Posts
    175
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Create new message from Contact (Outlook XP)

    I have checked with ISP. 500 recipents in bcc is only one message.

  6. #6
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Blacktown, Sydney, New South Wales, Australia
    Posts
    175
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Create new message from Contact (Outlook XP)

    Thanks John,

    That just might do the trick. Will look into it further.

    Maybe we confused each other earlier. When I send an e-mail with 500+ recipients, there is only one e-mail in the outbox. ISP confirmed, that although there are 500 recipients, I have only sent 1 e-mail. Therefore if PDF attachment is 1 mb, then that is my upload for that e-mail, not 500 mb. As my monthly allowance is only 200 mb, and I have sent a few issues out, this would seem to be confirmed.

    Thank you for your help, I will certainly look at the code you provided, and alter as required.

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

    Re: Create new message from Contact (Outlook XP)

    I don't think your ISP realizes the extent of server resources they will use to disseminate the message, but it's a good arrangement for you. Note that I fixed a couple of lines of the code.
    -John ... I float in liquid gardens
    UTC -7ąDS

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

    Re: Create new message from Contact (Outlook XP)

    <P ID="edit" class=small>(Edited by JohnBF on 28-Jun-04 19:42. Code corrections.)</P>I'm surprised. Here's some starter code to pull the category "Newsletter" from a selected Contacts folder and place every person with an e-mail address into the bcc line of an open current window message draft.

    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 addtobcc()
    Dim lngC As Long
    Dim itmMessage As Outlook.MailItem
    Dim recBCC As Outlook.Recipient

    On Error Resume Next
    Set itmMessage = GetCurrentItem ' with the target draft message open and active

    If Not itmMessage Is Nothing Then
    With Outlook.GetNamespace("MAPI").PickFolder
    For lngC = 1 To .Items.Count
    If .Items(lngC).Class = olContact And InStr(.Items(lngC).Categories, "Newsletter") Then
    If Len(.Items(lngC).Email1Address) Then
    Set recBCC = itmMessage.Recipients.Add(.Items(lngC).Email1Addre ss)
    recBCC.Type = olBCC
    End If
    End If
    Next lngC
    End With
    End If

    Set recBCC = Nothing
    Set itmMessage = Nothing
    End Sub
    -John ... I float in liquid gardens
    UTC -7ąDS

Posting Permissions

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