Extra attachment in mail automation

Help StudioX
,
1

This image shows a list of Word document files with varying sizes under the categories "Subject" and "Performance Letters," with most file names redacted for privacy. (Captioned by AI)
This image shows a list of Word document files with varying sizes under the categories "Subject" and "Performance Letters," with most file names redacted for privacy. (Captioned by AI)948×244 71.7 KB

The image shows a UiPath automation workflow configuring the "Send Email" activity using the desktop Outlook app to send performance review letters via email. (Captioned by AI)
The image shows a UiPath automation workflow configuring the "Send Email" activity using the desktop Outlook app to send performance review letters via email. (Captioned by AI)1249×723 107 KB

i want to send the email with attachments in a single email, but there is always an extra attachment titled “~$n” that keeps appearing in the email attachment section, how can i remove this?

Forum Engagement Daily Reports
2

@Sherrie1 ,

Follow this:

In UiPath, the presence of an attachment with a name starting with ~$ typically indicates that you are trying to attach a temporary file that is generated by applications like Microsoft Excel or Word when you’re editing a document. These temporary files are created to manage changes and they usually start with ~$ followed by the original file name.

To avoid sending this temporary file along with your email attachments, you can follow these steps:

  1. Check the folder before sending: Before attaching files, ensure that you are only adding the intended files to your email. You can use the Directory.GetFiles method to filter out files with the ~$ prefix.

  2. Filter file attachments: You can use a list of file extensions and filter the files based on the names, excluding any file that starts with ~$. Here’s how you can do this in UiPath:

    • First, use the Assign activity to get the list of files from your directory:

      files = Directory.GetFiles("YourDirectoryPath")

    • Then filter out the unwanted files:

      attachments = files.Where(Function(f) Not Path.GetFileName(f).StartsWith("~$")).ToList()

    • After filtering, use the list attachments to attach files to your email.

  3. Sending the email: Finally, when you use the Send SMTP Mail Message or Send Outlook Mail Message activity, pass the filtered list of attachments.

Here’s an example workflow:

// Get list of files from a specific directory
files = Directory.GetFiles("C:\path\to\your\files")

// Filter out files that start with ~$
attachments = files.Where(Function(f) Not Path.GetFileName(f).StartsWith("~$")).ToList()

// Prepare the email activity
Send SMTP Mail Message
- Attachments: attachments
- Subject: "Your subject"
- Body: "Your email body"

By implementing this filtering process before attaching files to your email, you should be able to avoid sending the unwanted ~$ temporary files.

3

i do not have the assign activity in my studiox profile. and how do i use the directory.getfiles method?

4

In UiPath StudioX, which is designed for business users and less technical users, certain programming concepts and activities, such as Assign, are not explicitly available. However, you can still achieve the desired functionality by using the built-in activities and a different approach to filtering attachments.

Steps to Exclude Unwanted Attachments in UiPath StudioX

  1. Use the Get Files Activity: In StudioX, instead of Directory.GetFiles, you can use the Get Files activity to retrieve the list of files in a specified directory.

  2. Filter the File List Using the Use Feature:

    • After retrieving the files, you might need to create a new sequence to filter the files before sending the email.
    • While there isn’t an “Assign” activity, you can use a combination of the Filter Data Table activity or a straightforward If condition within a loop to check for file names.

  3. Use Send Email Activity: Once you have filtered the files, you can use the Send Email activity to send the email with the valid attachments.

Example Workflow Steps

Here’s a suggested approach:

  1. Get File Activity:

    • Use the Get Files activity to specify the folder where your attachments are stored. You can save the output to a variable named FileList.

  2. For Each Activity:

    • Drag and drop a For Each activity to loop through the items in FileList.
    • Create a variable (e.g., ValidAttachments) of type List<String> to store the valid attachments.

  3. Add an If Condition:

    • Inside the For Each, use an If condition to check if the current file does not start with the temporary file name pattern.
    • You can check if Not currentFileName.StartsWith("~$").
    • If the condition is true, use the Add to Collection activity (which is available in StudioX) to add the valid file to ValidAttachments.

  4. Send Email:

    • After the loop, use the Send Email activity to send your email.
    • In the attachments property of the Send Email activity, use the ValidAttachments variable that contains your filtered files.

Example of the Steps in StudioX

  1. Get Files Activity:

    • Properties:
      • Directory: C:\Your\File\Path
      • Output: FileList

  2. For Each Activity (where CurrentFile is the iteration variable):

    • Type argument: String

    Inside For Each:

    • If Activity:
      • Condition: Not CurrentFile.StartsWith("~$")
      • Then: Add to Collection (Add CurrentFile to ValidAttachments)

  3. Send Email Activity:

    • Set the Attachments property to ValidAttachments.

Summary

@Sherrie1
By using the combination of Get Files, For Each, If, and Add to Collection activities in StudioX, you can filter out unwanted attachments effectively without needing the Assign activity. This method keeps everything reusable and functional within the StudioX UI framework.