In Progress

Maschinensucher new

hi,

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

Status: Maschinennutzer

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.

Skills: Data Processing, Excel, Visual Basic

See more: maschinensucher, data str, abc company, vba open folder, str, sie, office vba, line sheet, julian, excel vba script, calc, csv script vba, excel 2011 vba, data processing vba, excel vba processing, save txt excel, blank fields, vba data processing, emails txt file list, sheet visual basic script, adress list, vba excel 2011, vba file list excel, vba 2011, status list excel

About the Employer:
( 19 reviews ) Stockstadt, Germany

Project ID: #1099371

Awarded to:

yehia111111

Hi Kindly,check Your PMB

€110 EUR in 2 days
(3 Reviews)
3.6

29 freelancers are bidding on average €156 for this job

bharanisrihari

Hello, Excel VBA expert here. Please check PM for details. Thanks!

€250 EUR in 7 days
(64 Reviews)
6.5
committed

Lets get this done. Please read your private message, Thanks!

€300 EUR in 4 days
(22 Reviews)
5.7
Krusche

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.

€250 EUR in 2 days
(28 Reviews)
5.6
tamrakar81

Hi , Please check PM . Thanks T

€100 EUR in 1 day
(40 Reviews)
5.0
gshiels

Please see PM

€200 EUR in 2 days
(11 Reviews)
4.9
chriskerpini

Please check PM.

€60 EUR in 2 days
(14 Reviews)
4.5
stacross

we'd like to bid on your "Maschinensucher new" project.

€145 EUR in 0 days
(19 Reviews)
4.3
bizdesign

Please see your PM.

€150 EUR in 2 days
(4 Reviews)
3.9
gurnit

You are in luck, I have the EXCEL VBA macro (proven and tested). Video attached in PM

€30 EUR in 0 days
(2 Reviews)
3.4
PG89

Hi, Please Check PM

€100 EUR in 6 days
(2 Reviews)
1.6
rrakib

sent pm. thnx

€30 EUR in 1 day
(0 Reviews)
0.0
shatuamin

Dear sir, I am expert on this work. Please send full details.

€200 EUR in 20 days
(0 Reviews)
0.0
dibilim

200 eur0s in finishing the task 0r my m0nthly charge.

€100 EUR in 2 days
(0 Reviews)
0.0
pmaish

please check my pm

€200 EUR in 2 days
(0 Reviews)
0.0
cobramk3

No problems.

€50 EUR in 10 days
(0 Reviews)
0.0
AuRex

Currently I write VBA code for ArcGIS at my workplace, so I know I can do this task.

€30 EUR in 1 day
(0 Reviews)
0.0
shaksalam

I am ready to work

€30 EUR in 3 days
(0 Reviews)
0.0
santu87

Hi, I have experience in similar kind of project. Please see PM for details approach. Thanks, Santu

€30 EUR in 1 day
(0 Reviews)
0.0
jackal80

Please check PMB for details, thanks.

€100 EUR in 2 days
(0 Reviews)
0.0
Drubodhk

Please see PMB for details.

€200 EUR in 5 days
(0 Reviews)
0.0