Email Format Issue - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

Email Format Issue

Author

Topic

sqllearner
Aged Yak Warrior

639 Posts

Posted - 2007-01-14 : 15:31:46

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

sqllearner
Aged Yak Warrior

639 Posts

Posted - 2007-01-15 : 14:22:15

Please help with this format issue.Thanks

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources