Are you emailing out the form as a docm? CommandButton1_Click() is a fairly generic name for a macro. If the user already has a macro by that name defined on their system, it's likely they are running that macro instead of the one you sent them.