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

Probíhá Zveřejněno před 5 lety K zaplacení v momentě doručení
Probíhá K zaplacení v momentě doručení

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.

Excel Microsoft Outlook Visual Basic pro aplikace

Identifikační číslo projektu: #16997118

O projektu

3 nabídek Projekt na dálku Aktivní před 5 lety

3 Freelnceři na tento projekt zveřejňují nabídky v průměru $54

mohds2

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 Další

$111 AUD za 1 den
(4 Recenzí)
3.0
areverence

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 Další

$25 AUD za 1 den
(0 Recenzí)
0.8