Đã hoàn thành

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.

Kĩ năng: Excel, Microsoft Outlook, Visual Basic cho Ứng dụng

Xem nhiều hơn: vb.net read tab delimited text file into datatable, vb.net 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

Về Bên Thuê:
( 0 nhận xét ) Australia

ID dự án: #16997118

Được trao cho:

lifeonatlantis

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 Thêm

$30 AUD trong 1 ngày
(0 Đánh Giá)
0.0

4 freelancer đang chào giá trung bình $48 cho công việc này

$25 AUD trong 3 ngày
(37 Nhận xét)
5.7
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 Thêm

$111 AUD trong 1 ngày
(4 Nhận xét)
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 Thêm

$25 AUD trong 1 ngày
(0 Nhận xét)
0.0