luke.sykes
New member
- Joined
- Sep 25, 2015
- Messages
- 1
- Reaction score
- 0
- Points
- 0
Hi All
I have a booking form we use to book VideoConferences and for some reason on the latest version the user gets the afore mentioned error.
I have seen lots of posts and questions on this but none that relate to my exact issue.
When the user clicks submit, the macro emails the completed form (Sheet only) to the dedicated inbox without a problem but then they get the runtime error and think its not worked, so submit it again. Its becoming a real problem and no matter what I do I just cant get my head around it.
The whole form is made up of 5 sheets;
Home
New_Booking
Amendment
Cancellation
Support
With a Submit button on pages
New_Booking
Amendment
Cancellation
Which has a macro to send that single sheet as an email attachment as per Ron De Bruins code
First of all I tried using modules to house the code which retuned the error. My thinking was that perhaps the sheet has been emailed and can no longer see the module as the module is part of the workbook and not that worksheet. After that so I pasted the code into the sheets VBA field instead but the error still comes up.
I am totally out of ideas, please help
Kind regards
Luke
I have a booking form we use to book VideoConferences and for some reason on the latest version the user gets the afore mentioned error.
I have seen lots of posts and questions on this but none that relate to my exact issue.
When the user clicks submit, the macro emails the completed form (Sheet only) to the dedicated inbox without a problem but then they get the runtime error and think its not worked, so submit it again. Its becoming a real problem and no matter what I do I just cant get my head around it.
The whole form is made up of 5 sheets;
Home
New_Booking
Amendment
Cancellation
Support
With a Submit button on pages
New_Booking
Amendment
Cancellation
Which has a macro to send that single sheet as an email attachment as per Ron De Bruins code
First of all I tried using modules to house the code which retuned the error. My thinking was that perhaps the sheet has been emailed and can no longer see the module as the module is part of the workbook and not that worksheet. After that so I pasted the code into the sheets VBA field instead but the error still comes up.
I am totally out of ideas, please help
Kind regards
Luke