Results 1 to 8 of 8
  1. #1
    Lounger
    Join Date
    Dec 2005
    Posts
    36
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Adding recipient in VBA (2003)

    I would like to add buttons to my Outlook toolbar to add receipients to email (instead of typing the name - 50% of my emails that are not replies are sent to 10 people). I used to have code that worked in Outlook 98 and 2000, but it no longer works in 2003.

    Does anyone have a subroutine to do this?

    Thanks!

    Larry

  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: Adding recipient in VBA (2003)

    Any code that worked in both Outlook 98 and Outlook 2000 would have been VBScript. Be warned that Outlook XP SP2 and subsequent versions of Outlook have an Object Model guard to prevent you from creating email viruses - you might want to find and install "ClickYes" elsewhere in this Forum.

    Untested VBA air code using a Distribution List named "Gangof10":

    Sub AddKrewe
    ActiveInspector.CurrentItem.Recipients.Add("Gangof 10")
    ActiveInspector.CurrentItem.ResolveAll
    End Sub
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    3 Star Lounger
    Join Date
    Aug 2004
    Posts
    361
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Adding recipient in VBA (2003)

    (Edited by HansV to make URL clickable - see <!help=19>Help 19<!/help>)

    This is not a VBA solution, but it is one that I use. The steps can be found at http://office.microsoft.com/en-us/assistan...0549911033.aspx

    It is easy to add user to it (individuals or lists). Basically it you are assigning a hyperlink to an email address.

  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: Adding recipient in VBA (2003)

    There appears to be a small error in the instructions - I think :

    Add e-mail addresses and subject lines
    1. In the Customize dialog box, in the Categories list, click File.

    should read

    1. In the Customize dialog box, in the Commands list, click File.
    -John ... I float in liquid gardens
    UTC -7ąDS

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Adding recipient in VBA (2003)

    Actually, the instruction is correct, but they should have mentioned that the Categories list is in the Commands tab of the Customize dialog.

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

    Re: Adding recipient in VBA (2003)

    That's odd, I don't see a Categories List in the Commands tab of the Customize dialog - is it context sensitive?

    BTW, playing around with this whole approach, I found it easier and more convenient to add the second part of the instructions under the existing "New" dropdown in Outlook 2003. I now have my work team and my family groups under there.
    -John ... I float in liquid gardens
    UTC -7ąDS

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Adding recipient in VBA (2003)

    The screenshot below shows what the dialog looks like in Outlook 2002. I don't have 2003.

  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: Adding recipient in VBA (2003)

    <img src=/S/blush.gif border=0 alt=blush width=15 height=15> Who knew the left side had a name? <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>
    -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
  •