WebSyndication Mail Merge Module

Help on Mail Merge

The excel sheet should contain at least one column with a header named "Email", having all the email addresses (see EmailListExample.xls).
Use in your email template fields between '<[' and ']>' brackets (see the EmailTemplateExample.html) to replace with the values from the excel sheet, where the column name in the excel sheet equals the name between the brackets in the email HTML template.
Example:

   Dear <[FirstName]>,

   Thank you for registering for <[ProductName]>
   etc.




Examples:
  • Excel sheet example
  • Email template example (right click and choose 'Save Target As...')

See for a good html editor the coffeecup editor.
Have a look here for email campaign tracking using Google Analytics.
Did you get an error message like 'The installation requires that assembly ADODB version 7.0.3300.0 be installed in the Global Assemble Cache' then install the MDAC by hand.

Last changes:
  • Version 2.2.0 (September 30 2010): Supports Windows 7 now.
  • Version 2.1.10 (11 March 2010): Supports x64 bits machines now.
  • Version 2.1.8 (21 February 2010): Supports email templates from MS Word, exported to html, including images within the document.
    Using MS Word, choose the Save as type "Web Page, Filtered" when saving the email template:
    Email template from MS Word export to HTML
    Be aware of the encoding of the document. In most cases, UTF-8 will do:
    Email template from MS Word export to HTML using right encoding
  • Version 2.1.1 (27 December 2009): Supports, besides html files, also .eml files as email templates now.
  • Version 2.0 (20 June 2009): Supports sending attachments now.
  • Version 1.9 (1 June 2009): Backups of error files, created after pressing the button 'Start mail merge', can be found in the C:\Users\\AppData\Local\WebSyndication.net\ErrorFiles folder.
  • Version 1.8 (21 Februari 2009):
    • Solved issue regarding security while writing email error file to disc
    • Added support for screen resizing
  • Version 1.7 (21 January 2009):
    • Support for sending email using SSL and SMTP authentication
  • Version 1.6.3 (20 January 2008):
    • Correction German progress-translation while sending emails
  • Version 1.6.2 (27 November 2008):
    • Correction progress-translation while sending emails
  • Version 1.6 (22 November 2008):
    • Supports multiple languages now: English, Spanish, German and Dutch;
    • Ignores email address duplicates in the excel sheet.
  • Version 1.5 (26 september 2008):
    • Support using different SMTP port now. The standard port is 25, however if you are bound to use an other port, type in the 'Email Settings' tab in the 'SMTP Server:' box mail.YourCompany.com:2525 where 2525 is the alternative SMTP port.
  • Version 1.4 (27 august 2008):
    • Supports virtual smtp servers now.
  • Version 1.3 (22 juli 2008):
    • Added setting for choosing to embed images (so images are visible off-line!) or link them the usual way by url's in HTML emails;
    • Support for email campaign tracking using Google Analytics;
    • Support for sending mail merges using Yahoo.
    • Error logfiles are correctly shown now in excel 2007.
    • Added specific Microsoft binary (adodb.dll) to deployment so the application will run without installation of MDAC.
  • Version 1.2 (20 juli 2008):
    • Supports the Office 2008 excel types now (besides Excel 97-2003). You might need to download the Office System Driver;
    • The sheets of the selected excel file can be picket from a dropdown list;
    • Support for sending mail merges using GMail.
  • Version 1.1 (10 september 2007):
      Images used in the email template are no longer send as an link to an url, but are embedded in the email.


For more information, suggestions and questions email to WebSyndication@gmail.com
© 2006-2010 WebSyndication.net