none
Help with Merging/Consolidating contacts RRS feed

  • Question

  • I have a couple thousand contacts that I need to consolidate. It is currently causing a problem with just the shear volume and my basic VBA skills. Here is an example

    Row1: XYZ Corp         ###-###-####             1234 Lane                                                John Smith

    Row2: XYZ Corp                                                                       J.Smith@XYZ.com

    Row3: ZZZ Corp         ###-###-###                                       A.Smith@ZZZ.com

    Row4: ZZZ Corp                                                 1234 Ave                                                 Alex Smith

    Please any help or direction would be greatly appreciated

    Thursday, March 15, 2018 4:16 PM

All replies

  • Hi,

    I'm not sure if I can understand what you want to achieve.
    I guess you want to merge (Row1 and Row2) and (Row3 and Row4).

    (1) But it would be impossible because there are no matching key (i.e. key to know Row1 and Row2 is about the same person).

    (2) If "J. Smith" is not duplicated (every person has different mail address from each other), it is possible to merge Row1 and Row2. We can recognize "John Smith" equals "J.Smith@XYZ.com".
    (If Jack Smith exists, this scenario is not available.)

    (3) Information of one person uses 2 rows, and it always appears in series.

    Which should I use, (2) or (3)

    Regards,

    Ashidacchi >> http://hokusosha.com/


    • Edited by Ashidacchi Friday, March 16, 2018 11:53 PM
    Friday, March 16, 2018 11:44 PM
  • Hi Laxmaxta,

    It has passed a week since I posted.
    Has your issue been resolved? 
    If not, please read my first post and explain what you want to achieve more concrete. I will make a sample code for you.

    Regards,

    Ashidacchi >> http://hokusosha.com/

    Friday, March 23, 2018 2:24 AM