configuring the email component

[sushantk19]

Hello All,

I have to configure tSendMail email component. I have to check if value is changing in one of the reference tables.

if yes, then send email to customer.

how to configure

tSendMail component for the 1st time? what values do i give in SMTP port, SMTP host, username and password?

I am using this component for the 1st time, Can someone please guide me?

[Anonymous]

Hello,

Here is online component reference about: TalendHelpCenter: tSendMail

Let us know if it helps.

Best regards

Sabrina

[sushantk19]

@Xiaodi Shi​ : thanks for your input. But, can you tell me what should i put for below SMTP configurations:

SMTP Host:

SMTP Port: should it be 25?

Username:

Password:

I need this information to create an email task for DW project.

[root]

These are standard properties that the relevant team can provide.

You need to work with your Email provider/ IT team for these details. HTH

[Anonymous]

Hello,

SMTP Port must be 25 which is commonly used and host will be your official mail server's IP or host name.

What's your mail server? Gmail or Outlook?

Best regards

Sabrina

[sushantk19]

it is Outlook.

[Anonymous]

Hello,

Here are the parameters settings I am using tSendMail to connect with office365.

[sushantk19]

Hello All,

Thanks for your response. the email functionality is working fine now.

However, need a small input. I want to send only 1 email for all my error records. Presently if there are 500 error records in my file, the job sends 500 emails :(. but it should send just 1 email with 500 records as Attachement( Attachement is working fine in existing job). is there a option/setting for this in email job?

[Anonymous]

Hello,

Could you please upload your job design screenshots on community? Are you using tsendmail component as a subjob with OnSubjobOK connector?

Best regards

Sabrina

[sushantk19]

I have attached my job screenshot. Yes I am using tsendmail component in my job. No, its not with OnSubjobOK connector. I just connected my input file with this tsendmail component. please suggest how to control the no of emails. it is flooding my inbox.