Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Email Format Issue

Status
Not open for further replies.

SqlHunter

Programmer
Jun 3, 2004
166
US
This is a part of the activex script of DTS package which sends out a mail.Is there any way I can format better than this
like a table which has 2 columns 1. Process Name 2.Record Count



oSendMailTask.MessageText = "**********PLEASE DO NOT REPLY TO THIS EMAIL ADDRESS*********" & VbCrLf & _
VbCrLf & _
"Process Name : Total Emp Status Update " & VbCrLf & _
"------------------------------------------------------------------------" & VbCrLf & _
"Total Records Received By IM1 = " & total_records_received_by_IM1 & VbCrLf & _
"Total Records Processed By IM2 To Uncleansed Database= " & total_records_processed_by_IM2_to_uncleansed & VbCrLf & _
"Total Records Unprocessed By IM2 To Uncleansed Database = " & total_records_unprocessed_by_IM2_to_uncleansed & VbCrLf & _
"Total Failed Records Processed By IM2 To Uncleansed Database= " & total_failed_records_processed_by_IM2_to_uncleansed & VbCrLf & _
VbCrLf & _
"------------------------------------------------------------------------" & VbCrLf & _
"Total Records Received To Cleansed Database= " & total_records_received_to_cleansed_by_ETL & VbCrLf & _
"Total Successful Match Consolidation In Cleansed Database = " & total_successful_match_consolidation_in_cleansed_by_ETL & VbCrLf & _
"Total Unprocessed Match Consolidation In Cleansed Database= " & total_unprocessed_match_consolidation_in_cleansed_by_ETL & VbCrLf & _
VbCrLf & _
"------------------------------------------------------------------------" & VbCrLf & _
"Total ETL Processed Records To Lead Staging Database = " & total_etl_processed_records_to_leadstaging & VbCrLf & _
"Total ETL Processed Records To Lead Assignment Database = " & total_etl_processed_records_to_leadassignment & VbCrLf & _
"Total ETL Processed Records To Lead Database = " & total_etl_processed_records_to_lead & VbCrLf & _
"Total ETL Processed Records To Lead History Database = " & total_etl_processed_records_to_leadhistory


 
Hi,

I think you've done pretty well with that already!

Regards,
Tom

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top