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.
Bookmarks