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.
Attached is a sample email we got every day. As you can see, the structure is almost the same. Only the no. of inquiries differs and the fields may differ, depending whether they have been filled out by user or not.
the file will be automatically saved is under: I:\Mailonizer\mail\inbox\FROM
In the Excel file attached you will find the structure I would prefer. If possible the conversion should start automatically or by automated computer task. Some more
one more thing, user sometimes several times inquire machines, hence it would be great if the file is filtered by double entries and same machine category and merge these lines or delete one of them.
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.