Consulting

Results 1 to 3 of 3

Thread: SaveAs Dialog Box

  1. #1

    SaveAs Dialog Box

    Well this seemed like an easy thing to do but after quite a bit of searching I still haven't found a way of doing it.

    Basically I just want to open the Outlook SaveAs dialog box using visual basic and be able to have a custom filename be entered automatically and the file to be saved as .msg format.

    Please someone tell me this is possible.

  2. #2
    Knowledge Base Approver VBAX Master Oorang's Avatar
    Joined
    Jan 2007
    Posts
    1,135
    Location
    AFAIK the only way to get that dialog in outlook is to either build your own or use the CommonDialogs api. There is some nice canned code for that here you should be able to just copy/paste: http://mvps.org/access/api/api0001.htm
    Cordially,
    Aaron



    Keep Our Board Clean!
    • Please Mark your thread "Solved" if you get an acceptable response (under thread tools).
    • Enclose your code in VBA tags then it will be formatted as per the VBIDE to improve readability.

  3. #3
    So does the Common Dialogs API look and function exactly the same as the Outlook SaveAs dialog?

    I cut and pasted that code into a module but can't figure out how to run it. Do I just put TestIt into a sub? and run that sub?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •