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.