Export data from Excel to Word doc using button

Hello,

Ok, I know it already had been discussed here and I tried to run code snippets published myself, but it was pretty complicated.

Here's the thing:
I have a worksheet with the data such as "ID", "Company Name", "Contact person", "Address", "Telephone", "Fax". Chances are, that I will need to add more "data types" in the future.

There won't be multiple data entries, so there will be only one company (one row).

The thing I want to be able to do after filling out all fields in Excel is to have some button that will say "Export to Word". After clicking on that button the Word document will be opened with data imported from Excel worksheet where I clicked the button. Can somebody help me?

I already set up the test document (Word) where I predefined places where the data will be placed after clicking the button in Excel.

I use Excel 2007 and I'm looking for some "universal" solution Just the basic stuff (not for me, Excel is not my cup of tea) that will create Word document with data from Excel after clicking on the button.

Thank you for your time and help.

Thomas

Hi John,

So I modified the code of excel workbook little bit, created document and set up the mail merge in it. The document (.docx) and .xlsm are stored in same folder. Unfortunatelly, when "Print All" button is pressed it gives me nothing but the error that the data could not be merged.

Excel workbook and Word document is attached so if you or somebody will get some time to take a look on it and help me, it'll be much appreciated.

Thank you

Thomas

Thanks a lot for your help. I really appreciate it.

Of course, I went through the code and didn't realize that I forgot to change it to A after I deleted other columns.

One (I hope that the last question) ... I don't know if you realized, but now when I hit "Print All" button, it will create document that has the name "Form Letters 1" or something like that. Is there any way to change it to something specific?

Thank you very much

Thomas

Hi John

No, I want to just specify the file name (somewhere in the code).

Thank you

Thomas