mass saving of mails

  • Thread starter Thread starter Lynn
  • Start date Start date
Hi Lynn,

are you interested in a non-programming solution? You can drag the items
into the windows explorer.
 
if there is any help, a macro will be good.

Michael Bauer said:
Hi Lynn,

are you interested in a non-programming solution? You can drag the items
into the windows explorer.
Click to expand...
 
Author: Eric Legault
Thema: Outlook SaveAs Dialog and SharePoint
Date: 2004/09/09
in this group

I had stored the message:

<quotation>
I think you've pretty much already answered your question! You're
right,
there is no way to programmatically control the Save As dialog via
Outlook
VBA. You'd have to use the FileDialog object exposed from the other
Office
object libraries, which is rarely a viable solution.

Unfortunately, Office is one of the only programs that knows how to
handle
Web Folders and access to SharePoint. Otherwise, you're stuck using
third-party ActiveX controls, but then you have to create User Forms or
a COM
Add-In. There are a handful of controls that handle Web Folders, but
not
well I've found. I think this one works, but I can't quite remember:

http://ccrp.mvps.org/index.html?controls/ccrpbdsvr5.htm

I remember researching this same problem extensively over a year ago,
and I
either settled on a folder view control from a company that I can't
recall
the name of, or I used the ShellView OCX controls (which was damn
complicated) from the Windows SDK. From what I remember, the web
folders
didn't work well with Win98, or they were just flaky to begin with.

The solution I created that I am referring to above was a COM Add-In
specifically designed to save .msg files to SharePoint 2001 Document
Libraries, and it had the ability to browse SPS folders. It was 95%
complete
before the project was abandoned because of the changes with SPS 2003.

BTW, if you are using SPS 2003, you also cannot use Web Services to
upload
documents to libraries, so there's another roadblock.

If I were you, I'd use Word to get the FileDialog object, because all
the
alternatives are a ROYAL PITA.

--
Eric Legault - B.A, MCP, MCSD, Outlook MVP
--------------------------------------------------
Job: http://www.imaginets.com
Blog: http://blogs.officezealot.com/legault/

Nick said:
Is there a way to use the same dialog that appears when you select "File >
Save As" in outlook, using VBA?

I have added a button to a command bar
When selected I want the Save As Dialog to appear

I want to be able to Save a selected email to a sharepoint document libary
as a .msg file.

I tried:

Dim oMail As MailItem
Dim strName As String
Set oMail = Me.ActiveInspector.CurrentItem
strName = oMail.Subject

oMail.SaveAs "http://sharepoint/site/DocLibrary/" & strName & ".msg",
olMSG

----> but this only saves directly to the specified location.


I want to be able to be prompted with the "SaveAs" dialog and parse the top
level sharepoint site name (which will automatically list all the available
document libraries on that site with a html view)

I tried using the common dialog:

Dim dlg As Object
Set dlg = CreateObject("MSComDlg.CommonDialog")
With dlg
.InitDir = "http://sharepoint/site/"
.MaxFileSize = 500 'Sets the maximum file size allowed
.ShowSave
End With

-----> but the common dialog does not work with sharepoint, so it will only
list the "explorer" view and display all the sub directories on that site.


I looked at an example on outlookcode.com of using the word dialog, but I
don't want to have any dependencies on other applications.

If you can display the SaveAs dialog from the File menu in outlook, how come
you can't call it from VBA in Outlook?
There has to be some way to natively call this dialog from within
Click to expand...
Outlook?
</quotation>
 
Back
Top