Kathleen_0422
Board Regular
- Joined
- May 5, 2011
- Messages
- 64
I am using some code I received here and have used it over and over again. I am faced with a new dilemna.....
I have sent email to users with a file attachment. Now they are in the process of responding and once they submit it automatically sends the file back to me. Fine and dandy if they are connected to the network......
But what if they are sitting on a plane and filling out the file and the vba can't connect live. Is there a way to get the process on an error check to save it as a draft and then send it when they are back on the network?
As always I appreciate any advice you can provide.
I have sent email to users with a file attachment. Now they are in the process of responding and once they submit it automatically sends the file back to me. Fine and dandy if they are connected to the network......
But what if they are sitting on a plane and filling out the file and the vba can't connect live. Is there a way to get the process on an error check to save it as a draft and then send it when they are back on the network?
As always I appreciate any advice you can provide.