Word Automation / Mail Merge

Discussion Ask a question
, ,
1

I often use word mailmerge to automatically generate microsoft word documents which contains repeatedly replaceable contents such as names, address, dates. Usually I use excel spreadsheet or Acess databaase (PC) as a datasource.

Is that possible to do the following:

  1. To store the templates in a wix dataset, say dataset A;
  2. the templates saved in the dataset A use dataset B of my site as datasource
  3. Clicking a form submission button on mysite will automatically do the word mailmerge process,
  4. If step 3 is not possible or too complicated, is it possible to open the template when I click the button, and when the template is opened, it is linked to the datasource namely dataset B.

I am quite familiar with mailmerge with my datasource stored on my PC, but never tried to link my template to a online database. Can anyone kindly give me any clue.

2

Hi,

Do you wish to automatically create and send emails or to generate word documents?
Sending emails on form submission is documented here however generating word documents within wix code is not possible.

3

Thank you Ido, I do need to generate word document.