Results 1 to 4 of 4

Email Hyperlink command button

Threaded View

damo_uk Email Hyperlink command button 06-14-2010, 01:00 PM
salimudheen Re: Email Hyperlink command... 06-15-2010, 07:29 AM
damo_uk Re: Email Hyperlink command... 06-15-2010, 10:14 AM
salimudheen Re: Email Hyperlink command... 06-16-2010, 04:46 AM
  1. #1
    Registered User
    Join Date
    03-04-2009
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    40

    Email Hyperlink command button

    Hello,

    I have created a document with a list of peoples emails.

    I want to create a command button that will select a range and select all the email hyperlinks and set up a single email to send to them.

    I can get the macro to select the range but it will only email the first one on the list, not the whole ground.

    Code is below:
    Private Sub Email_Leaders_Click()
        Range("D5:D17").Select
        Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
    End Sub

    I want the email to be to all 13 people however the number after hyperlinks(x) corresponds to the person who will be emailed... i.e. 1 is first on the list, 13 is last.

    Any ways round this? Simple as possible please!

    Many thanks,

    Damien
    Last edited by Leith Ross; 06-14-2010 at 02:03 PM. Reason: Added Code Tags

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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