Results 1 to 7 of 7

Concatenate cells to format email address recipient string

Threaded View

  1. #1
    Forum Contributor Rick_Stanich's Avatar
    Join Date
    11-21-2005
    Location
    Ladson SC
    MS-Off Ver
    Office365
    Posts
    1,167

    Concatenate cells to format email address recipient string

    Im using this right now but I need this to be more dynamic. (Have to add code for any user additions)
    'added email urls to hidden sheet "Misc data" (Sheet 7)
        sRecipients = (Sheets("Misc data").Range("A2") & ";" & Sheets("Misc data").Range("A3")) & ";" & Sheets("Misc data").Range("A4") & ";" & Sheets("Misc data").Range("A5")
    Im trying this to read cells in column F, but cant figure out how to string this together in the loop.
        With Sheets("Misc data")
            'Loop thru Column F
            sh7LastRow = .Cells(Rows.Count, "F").End(xlUp).Row
            Set sh7Range = .Range("F1:F" & sh7LastRow)
        End With
        For Each Sh7Cell In sh7Range
        sRecipients = Sh7Cell     'How to create string from cells on Sheet7 Column F
        Next Sh7Cell
    Any hints, tips or examples is appreciated.
    Last edited by Rick_Stanich; 06-05-2012 at 07:58 AM.
    Regards

    Rick
    Win10, Office 365

Thread Information

Users Browsing this Thread

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

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