Executing word mailmerge from Excel vba

Profkenny123

New Member
Joined
Jan 29, 2019
Messages
1
I am new to vba. I only use to record. I currently find myself in a situation above my knowledge. I have 6 word docs mailmerged to 6 Excel docs in the same folder. I named the .doc and it's corresponding source Excel doc with the same name. I want to create a form using ActiveX textbox and button. The button is assigned to a macro in Excel with options to look for a record as typed in the ActiveX textbox, in any of the 6 Excel docs, mailmerge it to it's corresponding word doc and bring it up in PDF format. And another button to bring a PDF document of all records in a merged docs.
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

Macropod

Retired Moderator
Joined
Aug 27, 2007
Messages
3,543
See Run a Mailmerge from Excel, Sending the Output to Individual Files in the Mailmerge Tips and Tricks thread at:
http://www.msofficeforums.com/mail-merge/21803-mailmerge-tips-tricks.html
As you appear to be using separate Excel workbooks and mailmerge main documents, the simplest approach would be to have the same macro in each of those workbooks. It's not apparent, though, where your "form using ActiveX textbox and button" would reside.
 

Watch MrExcel Video

Forum statistics

Threads
1,129,317
Messages
5,635,527
Members
416,862
Latest member
MGDlite

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top