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.
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:
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.
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%>
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%>