Configuring the output component and executing the Job

Procedure

Double-click the tFileOutputExcel component to display the Basic settings view and define the component properties.
Set the destination file name as well as the sheet name and then select the Define all columns auto size check box.
Save your Job and press F6 to execute it.
The tVerifyEmail component analyzes email addresses and corrects those that do not match what you have defined in the local and domain part options.
Right-click the output component and select Data Viewer to display the formatted email addresses.

tVerifyEmail matches input addresses against the rule you set in the LOCAL part options section and the parameters you set for the domain names.

The VerificationLevel output column returns the status as VALID, INVALID, CORRECTED and REJECTED according to what you set/selected in tVerifyEmail basic settings.

All email addresses labeled as CORRECTED have a suggested address in the SuggestedEmail output column.

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!