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

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.

Skills: Excel, Microsoft Outlook, Visual Basic for Apps

See more: read tab delimited text file into datatable, read tab delimited text file, create xml file tab delimited file, tab delimited file xml php, google tab delimited file, read tab delimited file mysql, python script parse tab delimited file, smarty tab delimited file, php upload tab delimited file, tab delimited file mysql, php upload tab delimited file mysql, mysql output tab delimited file, upload tab delimited file sql, merging tab delimited file, javascript query tab delimited file, convert tab delimited file delimited perl

About the Employer:
( 0 reviews ) Australia

Project ID: #16997118

Awarded to:


Hi! So, I downloaded your file and made the macro that creates the array already - it was actually pretty fun! I'd pretty up the macro a little bit more before sending it off, turning the Sub() into a Function() th More

$30 AUD in 1 day
(0 Reviews)

4 freelancers are bidding on average $48 for this job

$25 AUD in 3 days
(37 Reviews)

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 Sutarw More

$111 AUD in 1 day
(4 Reviews)

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 forma More

$25 AUD in 1 day
(0 Reviews)