Error while using SMTP mail message

i am trying to sent out mail using SMTP.
After Proving all the desired result
I am getting an error of :value could not be null.
I am not getting what is the exact error.

image

I am here sharing the snap sort of error as well.
Please let me know if possible

Regards

@office_work

can you check the value of the filename which you have passed is having null

and aslo you can check all the variables which you have passed in the smtp

image

These my directory from where i want to get only XLSX file


these are my variables which i have used.

1 Like

Though u r passing value as argument check whether u really have XLSX files in that folder
Only then it returns value with ur directory expression and this error won’t occur

It looks like u r passing array of files
If that’s case make sure u r passing in ATTACHMENT COLLECTION property as it accepts array of file paths

@office_work

@office_work

you are using any for each activity for the FILE_dir as it is a array of string type

if not use this

directory.getfiles(“folderpath”,“*.xlsx”).first

Brother i want to fetch all the files which is in the folder in .xlsx format.

Check in this aspect once @office_work

@office_work

Check this steps:

Ensure that you have provided a valid recipient email address in the “To” field. It should not be empty or null.
Verify that you have provided the correct SMTP server and port for your email provider. Make sure you have set up the SMTP server configuration correctly.
Ensure that the “From” email address is not null and is a valid sender’s email address.
Make sure you have provided a subject and body for your email. They should not be null.
Set an appropriate SMTP timeout value. If the SMTP server is taking too long to respond, it can result in this error.

Cheers…!

image

this is my folder path
C:\Users\Administrator\Desktop\New folder\Query_Result\RM_queries

@office_work

before to smtp activity

check whether your FILE_dir is having .xlsx files or not

FILE_dir.count

can you share the screenshot how you passed the values in smtp activity

how to count the file
please let me know the activity and expression for it

@office_work

use log message and pass this expression

FILE_dir.count

image

place it before the smtp activity and check

image

there are 13 xlsx file

@office_work

can you share the screenshot of the smtp where you passed the filename

or FILE_dir

1 Like

Is there any other parameter used as Filename in that activity @office_work

image

I have mentioned in the Properties Panel

Does body contain any Filename @office_work

No there is no other parameter used as filename in this activity.

no, Does body does not contain any Filename

1 Like

If u passing any argument like this
Remove the second empty one and try

@office_work

1 Like