G
Guest
Guest
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?
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?