Attach a dynamic named excel file in Email tool

[abhinabaroy09]

Hi,

I have a workflow in which I have an excel file which is named according to the latest date and stored. I would like to attach this excel file as an attachment and send to recipients using the email tool.

A snapshot of the workflow

So, basis the date today the file will be named '2017_08_04.xlsx', and the name will change when I run the workflow tomorrow (2017_08_05.xlsx).

Is there a way by which I can send out the latest files everyday as attachments when the workflow is run?

Thanks,

Abhinaba

[FreeRangeDingo]

The original instructions were to use "File name from field" when telling the email what to attach.  But, I think that's what is causing it to send one email for each record. 

[Jdelia]

yes

Have a great day,



John Delia

Reporting and Application Designer

Watch Operations Analytics

Nielsen

Oldsmar, Florida

(813)366-6814

"My work matters because my design and development skills build the reports
and tools to help the business determine its growth and direction."
#myMission

www.Nielsen.com


Nielsen Well-Being- The four pillars are: Physical, Emotional, Financial
and Social/Environmental.

[adnan2234]

Hello,

Were you able to resolve this error? I'm trying to send a dynamic file (file name has date timestamp) as an attachment and getting the following error message in the email tool:

Error: Email (9): Record#1: Error Opening file: c:\temp\MAV-PharmacyList_09062022013024.xlsx|||Sheet1: The filename, directory name, or volume label syntax is incorrect. (123)

[Shaaz]

How can we send multiple dynamic files as an attachment in 1 single mail ?

[Shaaz]

Do we have the solution for this ?

[Shaaz]

Create a new calculated field like below.

EmailPath: c:\temp\MAV-PharmacyList_09062022013024.xlsx

Call this calculated column in the email tool attachment field.

[lowkeyspglobal]

@drahn were you able to figure this out? Thanks!

[drahn]

Yes @lowkeyspglobal - I am doing this for a massive amount of suppliers every month. I think what had been tripping me up was trying to use the same file path for saving the file itself and grabbing it in the email tool. Someone else had pointed out that the attachment doesn't need the Sheet name on it. So, I just have separate fields:

ReportName is just what I use for a Subject Line in the email.

Path is what I am using to update the Excel file on my shared drive.

FileName is what is used to grab the file from the shared drive to attach to the email.

Updating the Excel files:

Sending the Email:

[czjames87]

I keep getting the error below: 

• Unable to Open archive for zipping: c:\temp\ryder\tmc\TMC North\BI\VZN\Weekly OB Delivery Report\VZN Weekly OB Report.xlsx Can't open file: c:\temp\ryder\tmc\TMC North\BI\VZN\Weekly OB Delivery Report\VZN Weekly OB Report.xlsx: The system cannot find the path specified. (3) (Tool Id: 139). 

I have created the logic below in order to create a dynamic attachment that will reflect the previous saturday's date. 

I have changed the output tool to the below: 

i have updated the email attachment to the below: yet i am still seeing the error above. What am i missing?