Hi Joao,
Thanks for your inquiry. You can easily use Excel document as data source. Since you can easily select data from excel file using
ADO.NET. It would be very easy to use these data for
mail merge.
You can also connect an Excel spreadsheet as an external data source to your input Word template document via the dynamic data exchange (DDE) system by using the code something like below:
Document doc = new
Document(@“C:\Temp\Doc1.docx”);
string excelDS = @"c:\Temp\Book1.xlsx";
MailMergeSettings mms = doc.MailMergeSettings;
mms.DataSource = excelDS;
mms.MainDocumentType = MailMergeMainDocumentType.FormLetters;
mms.DataType = MailMergeDataType.Spreadsheet;
mms.LinkToQuery = true;
mms.ViewMergedData = true;
mms.Query = "SELECT
* FROM " + mms.DataSource;
doc.Save(@"c:\Temp\out.docx");
I hope, this helps.
Best regards,