Find Jobs
Hire Freelancers

outlook vba - read from tab delimited file and return list of customers with a matched email as array for listbox control

$10-30 AUD

In Progress
Posted almost 6 years ago

$10-30 AUD

Paid on delivery
Need help writing a vba code to import a tab delimited text file into an array, return the list of clients that has matched email address for population as value for a listbox control in outlook vba. Please refer to attached file, there's 3 columns of data: client, address and email. Code to 1. import tab delimited file into array. 2. search through data under header called "email" and find anything matching "a@[login to view URL]". There may be multiple emails delimited by ";" in a record. If there is, code needs to go through those emails to find the "a@[login to view URL]" 3. return the list of clients with the matched email to be used in a code that populates as listbox control value in outlook. With the attached file, the filtered clients should be a, e, g and h. The listbox should be able to show those 4 clients as values for selection.
Project ID: 16997118

About the project

3 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
3 freelancers are bidding on average $54 AUD for this job
User Avatar
Hello, I am a EXCEL EXPERT - Macros(VBA) with 10 years of Exprience. I have already completed About 2000+ On Various Freelance Websites I can give you quality work in quick time Thank you Mohammed Sutarwala (Always work with a Proven Freelancer)
$111 AUD in 1 day
2.2 (4 reviews)
3.0
3.0
User Avatar
Hi, I am an excel expert and do have the professional capabilities to handle this job. I have already completed such tasks before for one someone. The data was in rough formatting text file which I organized in a formatted pattern as required. I am ready to work with you. Prices are negotiable. Please inbox me so that we can discuss further details. Kind Regards,
$25 AUD in 1 day
0.0 (0 reviews)
0.8
0.8

About the client

Flag of AUSTRALIA
SYDNEY, Australia
5.0
1
Payment method verified
Member since May 1, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.