Dont email form if certain cells are blank

[rfrederick62]

Good day all, I currently use a macro to send an "Order Form' (an excel sheet) to my Stores. The end-user fills out the form for items then hits a button on the sheet and the sheet is sent to Outlook and waits for the user to hit SEND (they have to c.c. certain people) and then the form goes to Stores email for printing and filling.
The problem is that many people 'forget' to fill out certain information- location , requester and quantity- so I have to return the form and/ or call them for the info - wasting valuable time.
What Id like is if they DO NOT fill in those cells they get a message back ("FORM INCOMPLETE- REDO") and the email process stops and they have to fill these cells in.....and this continues until all pertinent cells have the required information THEN it sends the form to Outlook....

thoughts?
thanks, Rob

 

[Fishboy]

There is no point in the macro opening Outlook etc (or doing any part of your code for that matter) if the blanks are found. As such I would use my code as the opening arguments as it checks for the blank cells right away and halts the code if blanks are found. You simply need to copy your macro (all of it except the sub name and end sub parts) and paste it on the end of my macro between the ' The rest of your code goes here comment and the end sub.

Obviously feel free to rename the sub back to whatever you want as it has no effect on the macro itself.

 

[rfrederick62]

got you! sorry i overlooked that- an insanely crazy day...your work is much appreciated!
cheers
rob

 

[Fishboy]

got you! sorry i overlooked that- an insanely crazy day...your work is much appreciated!
cheers
rob

You're most welcome mate. I'm slowly piecing this all together myself as I learn