LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I do an e-mail mail merge using an Excel spreadsheet? Gretchen Excel Worksheet Functions 0 July 19th 09 05:18 PM
quick key to send in e-mail jenn Excel Discussion (Misc queries) 3 December 4th 07 10:10 PM
E-Mail attachment to same e-mail address in Outlook Vick Excel Discussion (Misc queries) 4 May 17th 07 07:53 PM
Error: cannot load the mail service. Check your mail installation. Brad Bowser Excel Discussion (Misc queries) 0 December 20th 05 10:03 PM
General mail failure when sending e-mail from Excel Adrienne Excel Discussion (Misc queries) 5 November 4th 05 12:59 PM


All times are GMT +1. The time now is 02:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"