rfrederick62
New Member
- Joined
- Nov 25, 2014
- Messages
- 7
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
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