Merging 2 VBAs together, Email & Save

Hi All,

I have 2 VBAs which I need to work off of the same CommandButton1, is there someone out there who can help :-D

Please Login or Register  to view this content.

For the observant ones, yes, it's for a customer enquiry form, and it'll have commandbuttons to the other staff so the end user fills it out, clicks their name and it sends then saves it in the specified folder with the new sequential number as a .xls

i hope that makes sense, they both work separately but i cant get them to work together.

thanks!