email parsing automation

Email Parser

Extract data from emails and automate your workflow

The forum is now read only. Please, go to the the main Email Parser website if you need help.
Need help configuring the program? Have any questions regarding its use?
Is it possible to create a new excel file or sheet(in an existing file)?

I would like to:

1. Create a new excel file for each mail received, and name the excel file using one of the fields parsed from the email.
2. Create a new sheet in an existing excel file, and name the sheet using one of the fields parsed from the email.
Yes, it is possible. You can use field placeholders as usual. Take a look at the following screenshot:
fields_in_excel_from_email.jpg
Hi,

what is the placeholder for the actual system time?
I would like to create excel sheets with the actual system time and maybe date as filename.

Thank you.
You can use the field <%DateTimeRecieved%> but it formatted like this:

2017-02-16 14:23:50

In the attached screenshots there are examples for getting the date and time separately like this:

date: 2017-02-16
time: 14:23:50
time_without_dots: 14-23-50

Placeholders would be: <%date%>, <%time%> and <%time_without_dots%>
Attachments
parsing_date_and_time.jpg
parsing_date.jpg
parsing_time_1.jpg
parsing_time_2.jpg