VBA Code for mail merger & Printing

[Rayzor500]

I have a workbook that I need help with. On sheet 1 I have 4 command buttons: 1. New Client 2. Search 3. Print Mailing Labels, 4. Print Letters. I would like to be able to press the 4th button and it pop up with a form and ask for the date. When I punch in the date I want it to search through the array data of that date from sheet 2 and put the results in sheet 3. Then have it mail merge with a letter in word and print off automatically. Can anyone help me with this.

[mdmackillop]

Hi Rayzor,
Welcome to vbax.
To save us having to recreate everything, can you zip and post a sample workbook and document. Use Manage Attachments in the Go Advanced reply section.
Regards
MD

[Rayzor500]

Here is a sample file of the command button. I was wanting the data that I add go to sheet 2, the clients we had (Database), then when we perform the print it will show on Sheet3 but everytime i put in a new date I will need sheet 3 to refreash and also the mail merge in the letter.

[Rayzor500]

Here is the letter that also merger in it.