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
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