Using VB5, I have several fields in an underlying access database that contain large amounts of text. Buried in amongst these multiple fields, and subsequent text are email addresses, usually more than one, often several.
What I need to do is have a function or sub that will cycle thru the records, searching the text and extract all the email addresses, then write the addresses into a field, one address only per field, into an mdb table.
This table will then be used to generate auto reply responses to my contacts.
Probably, the process would search thru the text looking for the @ symbol. Then grab the text on either side.
Any ideas on how to do this. I;m new to VB so need a comprehensive solution.