How do I get File Save As Dialog Box for Attachments?

G

Guest

Can someone give me a code snippet that will pop up the MS-Outlook File Save
As dialog box for an attachment to a MailItem from within a VBA macro?

Thanks.

Mike M 91107
 
G

Guest

I guess I also need to understand how to make the Office.FileDialog.Show()
function available in Outlook. The File Save As dialog is part of the
Microsoft Office 11.0 Object Library. I have it checked under Tools ...
References in my VB Editor, but, do I have to do something special in code to
enable it inside an MS-Outlook macro?

Thanks.

Mike M 91107
 
K

Ken Slovak - [MVP - Outlook]

You can't. You'd have to open the system save dialog using a Win32 API call
and then do all the saving yourself in code.
 
K

Ken Slovak - [MVP - Outlook]

Open an instance of Word or Excel using code. That will also return to you a
file name to save to but it won't link with Outlook at all. In Word or Excel
code show the dialog.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top