i have an excel file. the sheet 1 is names as service report and sheet2 is
named as Lists. The service report sheet has been designed such that when a
service engineer speaks or done any work to a customer, he has to fill out
the customer details in the sheet . the form contains dropdownlists and free
text.

contact prodcut no
description completed?
name
email id
address
zipcode

like wise there are so many fields. the Lists sheet contains some data list
that is going to dropdownlist to show the items. this sheet is the hidden
sheet. what i need to do is. i need to place a command button so that when
the user presses the button it should validate the form and check whether any
field is left blank otherwise a popup should come and say fill out the
appropriate fields . if the all the fields are ok then it should give the
option to the user to specify the folder into which it is saved . this should
save only the service report worksheet , it should not include the lists
sheet. once it is saved it should be emailed to the customeremail id
(specified in the email id field) and also the service engineer
automatically.please if anybody has the code , please send it to me as iam
new to this macro

thanks
sheeba