Search and Print in VBA

**Ray_n_yellow** · 02-12-2009, 01:49 AM

I have a workbook that I have 4 buttons set up on the front page. With one button I press it would add the information into sheet 2 in a spreadsheet. What I want to do is - when I press button three I would like to put a date in and it search through sheet 2 and print out mailing labels from Publisher of those people within that date. I would also like to press button 4 and it print out a letter with it addressed (mail merger) to the person from sheet 2. Is this possible. I am unable to attach my file for it is too big to attach. Leave me a message and I will be able to send it through email.

**royUK** · 02-12-2009, 03:53 AM

If you can't attach a file, try using a zip program or use a free fie sharing site like yousendit.com & post the link.

**Ray_n_yellow** · 02-12-2009, 01:16 PM

OK here is my file - I removed the first two fourms and pictures for the file to upload.

**royUK** · 02-14-2009, 02:50 PM

Both your userforms look identical! Where are the mailing labels?

**Ray_n_yellow** · 02-16-2009, 08:47 PM

Yeah both forms are the same one to print mailing labels and the other to print a form made in Word. After the search is completed I need it to create a mail merge to go into the form and the address labels made in publisher and then print out automatically. Can this be done?