Need VBA Help! Trying to get worksheet to save and send.
I have an excel worksheet that I'm using as a form - sending to others to fill out and complete information. I have a button that when clicked will automatically bring up an email draft in outlook with my email address in the TO section, and the file is attached.... BUT, it is blank when sent! How can I get it so when others fill it out, it sends the form to me with their information?
What is the code this button triggers?
presumably the attachment is blank before you send it? Not it becomes blank whilst emailed
why not attach a sample file illustrating the problem.
Ok sorry - newbie here. The code right now is as follows. It is a blank form when I send it out. The recipients should fill it in accordingly and then press the "email this form" button to email it to me. Everything works, except it just emails it blank to me. Attachment 709254
Attachment 709255
Follow the instructions in the yellow banner, your attachment is invalid and wont open
See if the attachment now will suffice.
Please attach a version of your file which includes the macro you are currently using.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Ok what about now?
Are the users saving the file after they have completed it? If they don't save it, the macro will simply email you the original blank copy.
I'm trying to see if theres a way to make it automatically save their input and email to me.
Try the attached file. It will save the file to the user's desktop before creating the email.
I'm not seeing any coding?
It is in the worksheet code module. Right click the tab name for Sheet1 and click "View Code".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks