I have a macro that sends out 22 different reports, 2 per person. The reports get to the people, but my problem is when the user clicks on a command button on a form to send these 22 reports a chose profile box pops up each time and she has to click ok or hit the enter key. After 22 times this gets old really fast. How can I fix this? Thanks!