+ Reply to Thread
Results 1 to 2 of 2

Macro Needed - Email address / demographics clean-up

  1. #1
    Registered User
    Join Date
    12-08-2014
    Location
    Denver
    MS-Off Ver
    Office 2010
    Posts
    1

    Macro Needed - Email address / demographics clean-up

    Everyday I pull a spreadsheet of demographic data that includes name, DOB, and email address. I upload this spreadsheet to send out mail to all of the email addresses on the list. However, the data is always very dirty and takes hours to clean up. I need help creating a macro to do the clean up for me. The columns and data format never changes, but the amount of rows is always different.



    Here are the things i need to clean up.



    Delete entire row if any columns contain ","



    Delete entire row if Email address (column D) contains any special characters (< > / \ " ' : ; $ # ! % ^ & ( ) )



    Delete entire row if email address (column D) does not contain @ or "."



    Delete entire row if email address (column D) if contains @@ or .. (double symbols)



    Thanks,

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    31,279

    Re: Macro Needed - Email address / demographics clean-up

    Google: excel vba code to validate email address

    You'll find a few functions to validate an email address. All you then need to do is loop through the range calling the macro and taking appropriate action.

    Suggest you post some sample data for testing purposes if you need someone to put it together for you.


    Regards, TMS
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ 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. Using macro to find email address in address book of Outlook
    By danfullwood in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-22-2014, 06:48 AM
  2. Macro to PDF a sheet in workbook and email (outlook) to an email address in a cell
    By paul_sykes00 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-17-2012, 12:54 AM
  3. [SOLVED] Macro to clean and reformat address information
    By newnoise in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-25-2012, 04:51 PM
  4. Replies: 6
    Last Post: 12-02-2011, 02:14 PM
  5. Macro doesn't automatically resolve All email address when email is drafted
    By sonny.thind in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-23-2011, 12:58 PM

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