+ Reply to Thread
Results 1 to 6 of 6

Adding commas "," in email addresses for sending BULK Email stored cellwise..!

  1. #1
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2,521

    Adding commas "," in email addresses for sending BULK Email stored cellwise..!

    Adding commas "," in email addresses for sending BULK Email stored cellwise..!

    Dear Forum,

    I have around 200-250 Email addresses in an Excel Sheet and I need to send BULK Email to all these email addresses, however typing the same manually is tedious and time-consuming as its a regular activity every week-end.

    Is there a way by FORMULA or VBA whereby I could get all these email addresses in a single cell with commas in between each email address after the first and just before the last email address in the range.

    Warm Regards
    e4excel

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Adding commas "," in email addresses for sending BULK Email stored cellwise..!

    Only by using =A1 &"," & B1 etc. I suspect the result will be to big for the cell though
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2,521

    Re: Adding commas "," in email addresses for sending BULK Email stored cellwise..!

    No I know this way but I can split them into lets say 200 at a time or something which will make life easier when sending this BULK Emails..

    I am not sure but using VBA and some FOR LOOP will that be possible?
    Last edited by e4excel; 07-25-2011 at 07:39 AM.

  4. #4
    Valued Forum Contributor mohd9876's Avatar
    Join Date
    05-04-2011
    Location
    Amman, Jordan
    MS-Off Ver
    Excel 2010
    Posts
    426

    Re: Adding commas "," in email addresses for sending BULK Email stored cellwise..!

    Hi,
    you can write this function in a code module:
    Please Login or Register  to view this content.
    the insert a formula like this in the cell at which you need to join the emails:
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2,521

    Re: Adding commas "," in email addresses for sending BULK Email stored cellwise..!

    Wow Mohd,

    It works exactly the way I wanted one favour, please explain the code and also I am trying to get these email-ids as values ine one cell which is merged..

    Can I write the code when I am entering the Last Row No

    Col D------------------------Col E
    Max Entries 7021
    Starting Row 1
    Email ID for Ref# [email protected]
    Ending Row 29
    Email ID for Ref# [email protected]

    Modified code using INDIRECT for Dynamic Range
    Please Login or Register  to view this content.



    Now I have the Sr,No in Col A and Email Ids in Col B and a Blank Col C.

    I have merged cells D7 till K30 to display the email ids as values so that I can copy and paste this as a single chunk in my email account.


    So how do I write a Macro which on entering the value in the Ending Row gives me the direct copiable values in the merged Cell?

    Warm Reg
    e4excel

  6. #6
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2,521

    Re: Adding commas "," in email addresses for sending BULK Email stored cellwise..!

    I m getting an error for this code:

    Please Login or Register  to view this content.

    Can someone please help me on this...

+ 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