+ Reply to Thread
Results 1 to 9 of 9

setup an outlook email with multiple recipients using a userform

  1. #1
    Registered User
    Join Date
    06-27-2019
    Location
    UK
    MS-Off Ver
    2010
    Posts
    98

    setup an outlook email with multiple recipients using a userform

    I have a code that works for opening a new outlook email and adding 1 selected recipient but I would like to select multiple.

    Here is the code:

    Please Login or Register  to view this content.
    My goal is to open a userform. In listbox1 I will have a list of contacts. I have their email addresses saved in column 5 of listbox1. I would like to select multiple contacts and click an email button which would then open a new outlook email with the selected multiple addresses in the recipients tab. My code does this but only the first selected contact appears.

    Thanks for any help!
    Last edited by colin7; 09-12-2019 at 01:23 PM.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,995

    Re: setup an outlook email with multiple recipients using a userform

    I have not tested this so if it doesn't work please provide your file.

    Please Login or Register  to view this content.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Expert Kenneth Hobson's Avatar
    Join Date
    02-05-2007
    Location
    Tecumseh, OK
    MS-Off Ver
    Office 365, Win10Home
    Posts
    2,573

    Re: setup an outlook email with multiple recipients using a userform

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    06-27-2019
    Location
    UK
    MS-Off Ver
    2010
    Posts
    98

    Re: setup an outlook email with multiple recipients using a userform

    Thanks for taking the time to reply.

    6StringJazzer...I tried your code but the message box comes up saying No subcontractor selected.

    Kenneth. Yours works the same way my first code worked and only puts the first selected recipient instead of multiple selected.

    Any suggestions on how to fix this?

    Thank you

  5. #5
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MSO Home and Business 2024
    Posts
    7,351

    Re: setup an outlook email with multiple recipients using a userform

    See if this gets you going.

    Please Login or Register  to view this content.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  6. #6
    Forum Expert Kenneth Hobson's Avatar
    Join Date
    02-05-2007
    Location
    Tecumseh, OK
    MS-Off Ver
    Office 365, Win10Home
    Posts
    2,573

    Re: setup an outlook email with multiple recipients using a userform

    Please Login or Register  to view this content.

  7. #7
    Forum Expert Kenneth Hobson's Avatar
    Join Date
    02-05-2007
    Location
    Tecumseh, OK
    MS-Off Ver
    Office 365, Win10Home
    Posts
    2,573

    Re: setup an outlook email with multiple recipients using a userform

    Delete the Exit For or comment out if last post was not clear.
    Last edited by Kenneth Hobson; 09-12-2019 at 05:48 PM.

  8. #8
    Registered User
    Join Date
    06-27-2019
    Location
    UK
    MS-Off Ver
    2010
    Posts
    98

    Re: setup an outlook email with multiple recipients using a userform

    Bakerman2 & Kenneth, both your codes work perfectly.

    Thanks for your help!!

  9. #9
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MSO Home and Business 2024
    Posts
    7,351

    Re: setup an outlook email with multiple recipients using a userform

    You're welcome and thanks for rep+.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Help modifying the complex code
    By ggmkp in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-07-2019, 05:51 PM
  2. Modifying existing code
    By rhouston08 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-13-2015, 06:03 PM
  3. I need performance help and VBA formula processing help
    By kevinw89 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-13-2015, 05:50 PM
  4. modifying every other row code
    By ammartino44 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-03-2015, 01:49 PM
  5. Need Help Modifying Code
    By ayvee0 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-06-2013, 09:34 AM
  6. Help modifying code
    By brawcliffe in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-13-2009, 12:08 PM
  7. Help modifying code please.
    By nickm687 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-24-2007, 10:42 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1