VBA Excel Userform Sending Email

I guess I already did this wrong on my frist time post....I do hope this post is better....

Hello all! I'm working with an excel file, a userform and a command button. The command button is the main question here. Bascally when this button is clicked and email is sent to a specific person, me. This email also contains an attachment, and currently that is the active workbook open behind the userform. This works well, sort of. I sent this excel file to 5 co-workers to test. All but 1 worked OK. One, however, did not.

When the button was selected the standard Outlook message came up: "...an automated email is being sent on your behalf...select YES to continue..."...It all looks fine, but nothing happens...nothing shows up in their sent items folder and I do not receive this message.

Has anyone experienced this before? Is there a sitting with this users Outlook that prohibits the sending of automatic emails? Any ideas? I've added my command button code below...incase someone sees thing strange...(I am rather new to vba coding...)

Please Login or Register  to view this content.

Is the affected email address correct?

How ar you actally inptting the email address into the code? In the example yo have posted it is hard coded, you must have some way to change this within the code.

Youv'e marked this thread solved, what was the solution?