• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 854
  • Last Modified:

Saving .msg files to .doc +vb6.0

Hi,
Can anyone please suggests on how can I save .msg files to .doc +vb6.0
0
RIAS
Asked:
RIAS
  • 9
  • 6
1 Solution
 
tbsgadiCommented:
Have a look at the following:

http://www.bestshareware.net/download/outlook-eml-and-msg-converter.htm

Good Luck!

Gary
0
 
David LeeCommented:
Hi, RIAS.

Outlook can save messages directly into .doc format.  There's a caveat to that though.  Here's what Microsoft says on this: "Also note that even though olDoc is a valid OlSaveAsType constant, messages in HTML format cannot be saved in Document format, and the olDoc constant works only if Microsoft Word is set up as the default email editor."  If you are usign Outlook 2003 or earlier, then using Word as the email editor is an option.  If using Outlook 2007, then Word is the email editor, there is not option to use anything else.  Here's how you'd save a message into .doc format

objMessage.SaveAs "Some File Name", olDoc

You can also save items into Rich-text format (.rtf) and then open them in Word and save in .doc format.  To save a message in .rtf format, change olDoc to olRTF in the code sample.
0
 
RIASAuthor Commented:
Hi,
THe problem is I have .msg files in folder so not using outlook.exe directly..any suggestions on objMessage.SaveAs "Some File Name", olDoc


Cheers
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
RIASAuthor Commented:
Hi tbsgad,


Can you please copy and paste the code in here as cannot access this url ..security issue


Cheers
0
 
David LeeCommented:
Open the message in Outlook using the code I posted to your other question, then use the command above to save to .doc format.  Unless you are going to learn enhanced MAPI programming, then the only way I know of to read a .msg file is using Outlook.  There may be 3rd-party programs that use enhanced MAPI to read .msg files without Outlook, the one Gary linked to appears to require Outlook, but I'm not familiar with any.
0
 
RIASAuthor Commented:
oki mate will try .....
0
 
RIASAuthor Commented:
Hi,
Tried it but it doesnt convert it to doc format it saves it as file type

Code used:
olkMsg.SaveAs Foldername & olkMsg.Subject, olDoc


Am I  going wrong somewhere?

0
 
David LeeCommented:
Sorry, typo.  I omitted the extension.  Use this instead

    olkMsg.SaveAs Foldername & olkMsg.Subject & ".doc", olDoc
0
 
RIASAuthor Commented:
Hi,
Sorry no luck ..it errrors
0
 
David LeeCommented:
What's the error?
0
 
RIASAuthor Commented:
Hi,
It justs jumps out of the function on that linedon't really know

Cheers
0
 
David LeeCommented:
So it just stops running and doesn't display any error messages?
0
 
RIASAuthor Commented:
Yup..it jumps out of the function
0
 
RIASAuthor Commented:
Hi,
Manage to save it in txt ile thats fine..you r previous solution did work.thanks for that.
Now I need to set a printer which is different from default printer how do i  set it and get the .msg file printed with all its attachments in vb.

I tried your solution on other qustions:

Public Sub PrintMessagesAndAttachments()
    Dim objFSO As Object, _
        objFolder As Object, _
        objFile As Object, _
        objTempFolder As Object, _
        olkMsg As Object, _
        olkAttachment As Object
    Set objFSO = CreateObject("Scripting.FileSystemObject")
    Set objTempFolder = objFSO.GetSpecialFolder(2)
    'Change the folder path on the following line'
    Set objFolder = objFSO.GetFolder("C:\eeTesting")
    For Each objFile In objFolder.Files
        If objFSO.GetExtensionName(objFile.Path) = "msg" Then
            ShellExecute 0&, "print", objFile.Path, 0&, 0&, 0&
            Set olkMsg = Application.CreateItemFromTemplate(objFile.Path)
            For Each olkAttachment In olkMsg.Attachments
                olkAttachment.SaveAsFile objTempFolder & "\" & olkAttachment.fileName
                ShellExecute 0&, "print", objTempFolder & "\" & olkAttachment.fileName, 0&, 0&, 0&
            Next
        End If
    Next
    Set objFSO = Nothing
    Set objFolder = Nothing
    Set objFile = Nothing
    Set objTempFolder = Nothing
    Set olkMsg = Nothing
    Set olkAttachment = Nothing
End Sub

but it errors on the line
    Set olkMsg = Application.CreateItemFromTemplate(objFile.Path)

Should I post another question for this?


Cheers

0
 
David LeeCommented:
No need to open another question.  Here's the code for printing to a specific printer.
Sub PrintAttachmentToSpecificPrinter(Item As Outlook.MailItem)
    Dim wshNet As Object, _
        strCurrentDefault As String, _
        objFSO As Object, _
        objTempFolder As Object, _
        olkAttachment As Outlook.Attachment
    strCurrentDefault = GetDefaultPrinter()
    Set wshNet = CreateObject("Wscript.Network")
    'Change the printer name on the next line to that of the printer you want attachments printed to
    wshNet.SetDefaultPrinter "Microsoft Office Document Image Writer"
    Set objFSO = CreateObject("Scripting.FileSystemObject")
    Set objTempFolder = objFSO.GetSpecialFolder(2)
    For Each olkAttachment In Item.Attachments
        olkAttachment.SaveAsFile objTempFolder & "\" & olkAttachment.FILENAME
        ShellExecute 0&, "print", objTempFolder & "\" & olkAttachment.FILENAME, 0&, 0&, 0&
    Next
    wshNet.SetDefaultPrinter strCurrentDefault
    Set wshNet = Nothing
    Set objFSO = Nothing
    Set objTempFolder = Nothing
    Set olkAttachment = Nothing
End Sub
 
Function GetDefaultPrinter() As String
    Dim strPrinter As String, _
        intReturn As Integer
    strPrinter = Space(255)
    intReturn = GetProfileString("Windows", ByVal "device", "", strPrinter, Len(strPrinter))
    If intReturn Then
        strPrinter = UCase(Left(strPrinter, InStr(strPrinter, ",") - 1))
    End If
    GetDefaultPrinter = strPrinter
End Function

Open in new window

0
 
RIASAuthor Commented:
Cheers mate
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

  • 9
  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now