View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jordan Jordan is offline
external usenet poster
 
Posts: 144
Default Mail Rounting, Need help quick!! I'm under the gun on this.

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