Hello Experts,
Need your assistance...
I have a flat file with the following eight lines delimited by semicolon and then starts over again. Each record begins with an astrisk (*).
*Firstname Lastname;
firstname.lastname@email.a
ddress.com
;
Firstname;
Message to individual which can be several sentences. However, the message will end with a semicolon;
SenderName;
Date: 10/28/2009;
Circ# 90834908543;
Title: Title of the Book;
At present, I am copying the date from each record within the flat file (could be up to 100 records) and pasting content into an Outlook 2003 message content window as well as pasting the email address and sending each email one by one.
Is there any way I can set up a script to read this flat file and generate emails for me to send. Is there a setup in the Client side of Outlook 2003 to do this, i.e. have Outlook send messages locating the recipients email address, name, and subject, as well as message content from the flat file and send until (EOF)?
No sure the best way to go about this or if this is even possible. But there has to be a way to lessen the burden of manually doing this. I have a proprietary database that generates this flat file so I have to go off of this.
Any suggestions would be most helpful. Max points for this as I am not certain how easy/difficult it is and I do need a solution soon.
Thanks!
Mike
