The scenario:
I have a "Preview in Excel" button, that opens a excel template and populates the required fields and then saves the file.
I have a second button to email the document. If the user has previewed the document, outlook is opened with the document as an attachment, and other files required as attachments. If the user did not preview the document, a prompt comes up to do so.
What i need to do is... at the stage where the user has NOT previewed, and presses the "E-Mail" button, the document should be loaded into excel (which it does) AND then close excel automatically and open outlook (which is what i cant seem to get right).
If anyone has any ideas, it would be appreciated
I have a "Preview in Excel" button, that opens a excel template and populates the required fields and then saves the file.
I have a second button to email the document. If the user has previewed the document, outlook is opened with the document as an attachment, and other files required as attachments. If the user did not preview the document, a prompt comes up to do so.
What i need to do is... at the stage where the user has NOT previewed, and presses the "E-Mail" button, the document should be loaded into excel (which it does) AND then close excel automatically and open outlook (which is what i cant seem to get right).
If anyone has any ideas, it would be appreciated