I have created an application that sends emailsto multiple recipients.
I use a connection to Outlook to send the mail.
All is working well except that everytime some peice of information changes such as email address or name i have to amend my code and recompile.
Also for every address that i want to send to i have to have a seperate procedure and at the end of each it calls the next one.
is there a way i can hold all the details (email address etc) in an external file (such as CSV or TXT) that the application can read in and during a looping process goes through the list until it reaches the end and then continues with the program.
The details i need in my external file are Shop number (5 digits eg 00011), Shop Name (upto 25 char eg Northcote Road) and Email Address (eg [email protected])
In each loop of the procedure the following changes: Shop Name, Shop Number, Email Address.
Any help would be greatly appreciated

Thanks