userform button to mail merge

[StrawS]

Hi,

I am trying to mail merge an excel database. I have the word documents set up and I want to be able to click a userform button in the database to do the following:

• initiate the mail-merging word document
  automatically answer affirmative to the prompts
  initiate the merge-to-document function (answering further prompts)
  close the mail-merge document

After which, the new merged-to-document word application will be open and selected (with the database in the background).
Does anyone know if this has successfully been done before or how to go about it??

I'd be really greatful for any help at all
Thank you
Straws

 

[StrawS]

anyone got ideas on even part of this?

 

[ineedadedt]

Can anyone help on this? I too have the same issue.

Thanks!