Issue with Attaching Multiple Excel Files to a Single Email in Alteryx

Question

Hi Alteryx Community,

I'm encountering an issue when trying to attach multiple Excel files to a single email using a workflow I've created.

Workflow Details:

* I use a mapping file that contains the subject name and account number.
* I have a dictionary with file names that contain the account number.

With the current workflow, I'm able to send an email with a single attachment successfully. However, when I try to send multiple attachments, I receive the following error:
Record#3: Error
Opening file:
\path	o\file1.xlsx,\path	o\file2.xlsx: The system cannot find the path specified. (3)

It seems like the path might be an issue, but I'm not sure how to resolve it. I have verified that the paths are correct and the files do exist in the specified location.

Has anyone else experienced this issue or can provide guidance on how to correctly attach multiple files to a single email in Alteryx? Any insights or solutions would be greatly appreciated.

Thanks in advance for your help!

Best regards,

Dharmesh

Screenshot 2024-07-20 120616.png

Hadiram · Answer

I am also getting the same error as file is going in a temp folder, please see attached:

Avoid excel which has missing sheet in Dynamic input tool.yxzp

Maithreyan · Answer

Hi @Dharmesh91 ,

This Article might solve your use case - https://community.alteryx.com/t5/General-Discussions/How-to-attach-multiple-files-in-one-email/td-p/1093169

If the above did not help, try these steps:

1. If the file is located in a network path, pass in the UNC path rather than the absolute path ( Ex : C:/Files/test.xlsx )

2. Try to add files manually in the Email Tool using the add file functionality, instead of adding it manually by comma separated paths

Attach your workflow for better assistance.

Regards,
Maithreyan S

flying008 · Answer

Hi, @Dharmesh91

Could you please show the screenshot by option of Attachments: in Email tool ?