SendMail

Feb 27th, 2002, 05:43 PM

I am trying to automate sending an active Excel workbook as a shortcut in an email - so that a number of recipients can update the same workbook.
There does not seem to be any options to send the workbook as a shortcut. My other option was to create a shortcut to the workbook and then email the shortcut. I can do both of these manually but not through automation. The closest I have got is:
Application.Dialogs(xlDialogSendMail Array("MyEmailAddress"), Subject:="No Subject", ReturnReceipt:=True)).Show ' or
ActiveWorkbook.SendMail Recipients:=Array("MyEmailAddress"), Subject:="No Subject", ReturnReceipt:=True

Do you have any ideas?

Feb 27th, 2002, 05:47 PM

http://www.mrexcel.com/board/viewtop...ic=778&forum=2

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

Feb 27th, 2002, 05:43 PM	#1
Guest Posts: n/a	I am trying to automate sending an active Excel workbook as a shortcut in an email - so that a number of recipients can update the same workbook. There does not seem to be any options to send the workbook as a shortcut. My other option was to create a shortcut to the workbook and then email the shortcut. I can do both of these manually but not through automation. The closest I have got is: Application.Dialogs(xlDialogSendMail Array("MyEmailAddress"), Subject:="No Subject", ReturnReceipt:=True)).Show ' or ActiveWorkbook.SendMail Recipients:=Array("MyEmailAddress"), Subject:="No Subject", ReturnReceipt:=True Do you have any ideas?

Feb 27th, 2002, 05:47 PM	#2
Guest Posts: n/a	http://www.mrexcel.com/board/viewtop...ic=778&forum=2