Excel 2000...Send To feature

axcelis · Apr 8th, 2002, 01:53 PM

Hello,

Does anyone know a way in Excel 2000 to set the Send To feature to always chose Mail Recipient or Mail Recipient (as Attachment)? I am using this option under File, Send To. I would like it to always use Mail Recipient...is this possible? This didn't do this when I had Excel 97. Please respond if you know.

Thank you!

Anne Troy · Apr 8th, 2002, 01:55 PM

Why not try using the little envelope icon on your toolbar instead?

axcelis · Apr 8th, 2002, 02:07 PM

Thank you for your response. The Mail icon works, but I'm looking for it to be able to automatically always pick sending the workbook as an attachment, so I don't need to say OK each time. Actually, this is for a customer of mine who is looking to do this. I told him I'd look to see if it is possible to always have it "turned on", you could say. DO you know is that is possible?

Thank you!

Jack in the UK · Apr 8th, 2002, 05:13 PM

Hi

VBA code can just send an email with or without an attachment and text.

try right click on the doc and sent to - choose who TO and send..

this agrio is a control point or ypur be like me sending email all over the world to the wrong guys... er,,,!

takes seconds but is a pain i know...

Can i suggest search for emails bundells there to see and select what a winner for you. poss some editing the VBA code should be all OK.

Rdgs

Apr 8th, 2002, 01:55 PM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	Why not try using the little envelope icon on your toolbar instead? __________________ ~Anne Troy

Apr 8th, 2002, 05:13 PM	#4
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	Hi VBA code can just send an email with or without an attachment and text. try right click on the doc and sent to - choose who TO and send.. this agrio is a control point or ypur be like me sending email all over the world to the wrong guys... er,,,! takes seconds but is a pain i know... Can i suggest search for emails bundells there to see and select what a winner for you. poss some editing the VBA code should be all OK. Rdgs __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 8th, 2002, 01:53 PM	#1
axcelis New Member Join Date: Apr 2002 Location: Boston, MA Posts: 2	Hello, Does anyone know a way in Excel 2000 to set the Send To feature to always chose Mail Recipient or Mail Recipient (as Attachment)? I am using this option under File, Send To. I would like it to always use Mail Recipient...is this possible? This didn't do this when I had Excel 97. Please respond if you know. Thank you!

Apr 8th, 2002, 02:07 PM	#3
axcelis New Member Join Date: Apr 2002 Location: Boston, MA Posts: 2	Thank you for your response. The Mail icon works, but I'm looking for it to be able to automatically always pick sending the workbook as an attachment, so I don't need to say OK each time. Actually, this is for a customer of mine who is looking to do this. I told him I'd look to see if it is possible to always have it "turned on", you could say. DO you know is that is possible? Thank you!