we get a list of inquiries via email each day. The email is standardized and includes adress, name, company, a machine category and more. The emails are saved on the drive in txt file format.
Now I would like to have a VBA script in Excel or open office calc, that is able to go in the specific folder and open the latest email/txt file and put the data (adress, name etc.) in a Excel spread sheet, save it as csv file so we can further upload it into Outlook and mailing software each day. The first line contains: company, name, street, place, machine category ...so actually the title of the fields. The following lines include the specific content that has been filled out by customer.
Here is an example (the item on front of the ':' is field name and after the content entered by customer, adress is in the second line):
Firma: Gampper Armaturen GmbH, Name: Julian Gampper
Niedermoscheler Str.2 67821 Alsenz
Tel: 06362 3020, Fax: 06362 30226, eMail:
Kategorie: Werkzeugmaschinen,Metallbearbeitungsmaschinen, Drehmaschinen , CNC Dreh-Fraeszentren
Kontaktwunsch: per eMail
Anfrage an Sie:
Suche 'CNC Drehmaschine INDEX ABC' oder aehnlich
Tricky here: the adress contains street and no. As well as zip code and place. This should be separated. Also field left blank by customer dont appear, eg Firma: is blank, then it doesnt appear.
Alternatively the email can also been processed directly from Outlook and saved as csv file
Tomorrow i will attach the email and draft excel file to show more.
29 freelancers are bidding on average €156 for this job
Hallo. Im PM ist ein Prototyp der Anwendung zu finden. Unser Angebot schließt die folgenden Punkte ein: Konvertierung, Scheduled Task (entweder von der Anwendung selbst oder ein .bat), Entfernung der Duplicate.