Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I have a form that I need to be able to send to people, have them fill out electronically and send back to me. I am trying to use the routing function so that when they click the macro button an email is automatically generated back to me with form attached. Right now this(see code below) is the best way i can come up with for accomplishing this. But their is this message that keeps popping up on all their computers that says "If you want to track reviewers' changes in this workbook you need to make this workbook shared, do you want to save a shared version of this workbook?" I really want to get rid of that question, it is just a major inconvenience because lots of people get these forms and they all stop in their tracks when they see that and don't know what to do. This is the code I am using so far... ActiveWorkbook.SendForReview _ ", _ Subject:="Here is the Acknowledgement that you requested", _ ShowMessage:=False, _ 'I don't know what ShowMessage does IncludeAttachment:=True I was also considering placing a hyperlink in the document and have the macro just follow the hyperlink, but then how would i attach the document that they just filled out? The other problem is that We use Lotus Notes and I email to people with all sorts of different programs, (e.g. Outlook, or even just hotmail or yahoo accounts) so i don't even know if this will work at all. Thank you so much for any help with this, Jordan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I do an e-mail mail merge using an Excel spreadsheet? | Excel Worksheet Functions | |||
quick key to send in e-mail | Excel Discussion (Misc queries) | |||
E-Mail attachment to same e-mail address in Outlook | Excel Discussion (Misc queries) | |||
Error: cannot load the mail service. Check your mail installation. | Excel Discussion (Misc queries) | |||
General mail failure when sending e-mail from Excel | Excel Discussion (Misc queries) |