+ Reply to Thread
Results 1 to 7 of 7

Concatenate cells to format email address recipient string

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

    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)
    Please Login or Register  to view this content.
    Im trying this to read cells in column F, but cant figure out how to string this together in the loop.
    Please Login or Register  to view this content.
    Any hints, tips or examples is appreciated.
    Last edited by Rick_Stanich; 06-05-2012 at 07:58 AM.
    Regards

    Rick
    Win10, Office 365

  2. #2
    Forum Expert
    Join Date
    06-25-2009
    Location
    Sofia, Bulgaria, EU
    MS-Off Ver
    Excel 2003-2013
    Posts
    1,290

    Re: Concatenate cells to format email address recipient string

    Hi,
    try this

    Please Login or Register  to view this content.
    Hope it will help.

    buran
    If you are pleased with a member's answer then use the Star icon to rate it.

  3. #3
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: Concatenate cells to format email address recipient string

    Completely untested, but try this

    Please Login or Register  to view this content.
    Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
    I am the real 'Napster'
    The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...

    If you receive help please give thanks. Click the * in the bottom left hand corner.

    snb's VBA Help Files

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

    Re: Concatenate cells to format email address recipient string

    Thank you buran and JapanDave
    Both examples work!

  5. #5
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: Concatenate cells to format email address recipient string

    Glad it worked for you. Cheers Dave

  6. #6
    Valued Forum Contributor StevenM's Avatar
    Join Date
    03-23-2008
    Location
    New Lenox, IL USA
    MS-Off Ver
    2007
    Posts
    910

    Re: Concatenate cells to format email address recipient string

    It would help if you could upload a workbook illustrating how your data is storied.

    It seems to me that you are trying to collect information stored on a worksheet into a string.

    If so, that is a perfect task which can be given to a function.

    But to answer your question, you might try something like:

    Please Login or Register  to view this content.

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

    Re: Concatenate cells to format email address recipient string

    Thank you!

+ Reply to Thread

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