+ Reply to Thread
Results 1 to 2 of 2

Problem in vlookup formula in e-mail data

  1. #1
    Registered User
    Join Date
    07-28-2020
    Location
    Melbourne,Australia
    MS-Off Ver
    365
    Posts
    13

    Problem in vlookup formula in e-mail data

    I have an outlook email data. My final aim is to do email marketing on this final outlook data. So, I need e-mail and name of the person to send those e-mails. I already cleaned email data but some of the emails I am not able to find the customer name. In order to find customer name, I am using body of the email and then text cleaning. I have used vlookup to find but unable to do the task successfully as we need to exchange multiple email to one clients.

    I have two tabs 1. original data 2. e-mails matched. So, in e-mails matched I want the body of those email ids. You get body from original data. Data is already attachedwith name "Proof excel data". If there is any other way in excel that we can do this task, please let me know.
    Last edited by Glenn Kennedy; 12-04-2020 at 04:20 AM.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    29,839

    Re: Problem in vlookup formula in e-mail data

    I have removed your attachment. It looks as though it contained many, many REAL email addreses. This is a violation of the Data Protection laws that apply here in Ireland and, probably, also in Oz. It was also very large, but that is a side issue.

    Please re-attach a SMALL set of imaginary email addresses with expected solutions. Usually 10-20 rows is plenty. No-one is going to want to manually check 1Mb++ of a zip file full of email addresses!!
    Glenn



+ 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. Mail Merge problem - Header Title doesn't match data
    By shrew82 in forum Word Formatting & General
    Replies: 1
    Last Post: 08-25-2017, 09:13 AM
  2. [SOLVED] VLOOKUP formula problem
    By macrorookie in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-04-2014, 10:14 PM
  3. Mail variable number of sheets in workbook based on VLOOKUP mail address
    By Tino XXL in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-08-2013, 08:44 AM
  4. Problem with using VLookup formula
    By mal.b.graham in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-27-2012, 09:46 AM
  5. Replies: 9
    Last Post: 08-13-2012, 08:00 AM
  6. Problem with moving numberic data read in mail merge add .00001 after all numrict value
    By santosh226001 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-27-2012, 03:47 AM
  7. Loop + Data validation list + e-mail problem
    By VBA Noob in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-11-2006, 04:37 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