Hi there everyone,
I have a worksheet macro (embedded in the worksheet object) that is triggered when the user double clicks in a particular cell. This actions the emailing of that sheet, with the macro still contained inside when it is received by the recipient so that it can work their end.
When the recipient receives the worksheet, the macro allows them to double click to email it back to me.
The trouble is that they can't do this without first saving their Outlook attachment first to a location because an error message comes up saying it is a read only file. So they can't click in the attachment in Outlook, add a couple of things and use the email back function whilst still in the attachment. Unfortunately they have to save it somewhere first and then go into it.
Using work computers, security is rather high here so a file cannot be automatically saved simply to C, it has to go through personalised user named folders where you can dump files. Is there a generic folder location in Outlook 2007 where a file can be saved so that then an email can be fired using the location of the Workbook when generating the attachment?
Code I am using for automatic email is
With ActiveWorkbook
.SendMail Recipients:=EmailRecipient, Subject:=EmailSubject
.Close SaveChanges:=False
End With
I have a worksheet macro (embedded in the worksheet object) that is triggered when the user double clicks in a particular cell. This actions the emailing of that sheet, with the macro still contained inside when it is received by the recipient so that it can work their end.
When the recipient receives the worksheet, the macro allows them to double click to email it back to me.
The trouble is that they can't do this without first saving their Outlook attachment first to a location because an error message comes up saying it is a read only file. So they can't click in the attachment in Outlook, add a couple of things and use the email back function whilst still in the attachment. Unfortunately they have to save it somewhere first and then go into it.
Using work computers, security is rather high here so a file cannot be automatically saved simply to C, it has to go through personalised user named folders where you can dump files. Is there a generic folder location in Outlook 2007 where a file can be saved so that then an email can be fired using the location of the Workbook when generating the attachment?
Code I am using for automatic email is
With ActiveWorkbook
.SendMail Recipients:=EmailRecipient, Subject:=EmailSubject
.Close SaveChanges:=False
End With
Last edited:
