Topic Options
#45375 - 11/08/13 04:59 AM How to set the name of email subject & attachment
Andy1974 Offline
OL Guru

Registered: 03/26/08
Posts: 110
Loc: Hong Kong
Dear all,

I face one problem on send email subject and file name of attachemnt.

My case is I've prepared one excel file and I want thru
planetpress to send email & attach this excel file to our company user.

However, this excel file is generated in every beginning month.
And file format is "AAAA/BBB sales data.xls", AAAA is current year, e.g. 2013, BBB is last month, e.g. current month is NOV, so set BBB to OCT, so file name is "2013/OCT sales data.xls".

Also, the email subject is same as attachment, e.g. current month is NOV, email subject should be 2013/OCT sales data.

Now, I don't have any idea on how to set this excel file name
& email subject, and how to add this excel file in 'Attachment'
because the file name is different in every month.

Do anyone can give me some idea on it ?

Many thanks !
Best REgards,
Andy..

Top
#45379 - 11/08/13 03:59 PM Re: How to set the name of email subject & attachment [Re: Andy1974]
Raphael Lalonde Lefebvre Offline
OL Expert

Registered: 10/14/05
Posts: 4953
Loc: Objectif Lune Montreal
Hi Andy,

You could try using a Folder Capture to capture the Excel file in your data stream, then use a Rename action to rename it to %o, the original file name. (job files are renamed with a random name when captured) Then, you can use a Send Email output, and you'll notice that the subject is a variable data field. So you could use "%f" to get the current job file name as the email's subject. Then go to the "Attachment(s)" tab, and check "Attach input job file" to add the .xls file as an attachment.

Hope that helps!

Regards,
Raphaƫl Lalonde Lefebvre

Top
#45386 - 11/11/13 04:16 AM Re: How to set the name of email subject & attachment [Re: Andy1974]
Andy1974 Offline
OL Guru

Registered: 03/26/08
Posts: 110
Loc: Hong Kong
Hi Raphael,

Many thanks your reply on my question and I'll try to do it.

Thank you & Best Regards,
Andy...

Top