mail for ASP.NET email smtp mail for ASP.NET email smtp
mail for ASP.NET email smtp

Other Products
mail for ASP.NET email smtp
  "You really have the best customer support I've ever seen! "
T. Voulgaris
Find Your Friends
 
   More Testimonies

Intermediate Mail Merge Example

Back to index.

The following example builds off of the simple mail merge example. Besides just replacing the 'To' field with database fields, you can also replace text in the subject line of your email using the mail merge method. In our database, we are also storing the first name of our members, and we will add that field to the subject line of the email. Again, to add a database field to and email, you need to surround the the field name with '##'.

See the example below.

Email Server
From Email Address
To Email Address
Email Subject
Email Body Contents
 

 

For your reference, here is what the database looks like below.

fldEmailfldFirstNamefldLastNamefldDatePurchasedfldAmount
user1@aspnetemail.comBobJones3/13/2002 12:00:00 AM10
user2@aspnetemail.comSteveCantoo3/14/2002 12:00:00 AM20.25
user3@aspnetemail.comJoanDew3/12/2002 12:00:00 AM18.15
The box is not shipped.
aspNetEmail is a    
downloadable product.
 
aspNetEmail
Voted Number 1 ASP.NET Email Control
Voted Best Email Control


aspNetEmail
Runner Up ASP.NET Email Control
Voted Runner Up Email Control


aspNetEmail
Voted Number 1 ASP.NET Email Control
Voted Best Email Control


aspNetEmail
Voted Number 1 ASP.NET Email Control
Voted Best Email Control


aspNetEmail
Voted Number 1 ASP.NET Email Control
Voted Best Email Control


aspNetTraceRoute
Voted Runner Up Networking Control
Runner Up - Networking Control

 

For your reference, here is the data found in the database.