![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
![]()
Does anyone have the vba code to print an Tiff/JPG attachment?
I am writng a code that will print a selected E-mail and all attached documents. So far Iam able to print .doc and .xls attachments, I am missing the correct code to print .tif and .jpg attachment. Below is my code sofar: Sub MyPrint() Dim myOlApp As New Outlook.Application Dim myOlExp As Outlook.Explorer Dim myOlSel As Outlook.Selection Dim Atmt As Attachment Dim FileName As String Dim PrtProg As String Dim cmd As String Dim x As Integer Set myOlExp = myOlApp.ActiveExplorer Set myOlSel = myOlExp.Selection For x = 1 To myOlSel.Count myOlSel.Item(x).PrintOut For Each Atmt In myOlSel.Item(x).Attachments FileName = "C:\Windows\Temp\" & Atmt.FileName Atmt.SaveAsFile FileName Select Case Right(FileName, 3) Case "xls": Dim xlApp As Excel.Application Dim wb As Excel.Workbook Set xlApp = New Excel.Application Set wb = xlApp.Workbooks.Open(FileName) wb.PrintOut xlApp.Quit Set wb = Nothing Set xlApp = Nothing Case "doc": Dim wdApp As Word.Application Dim doc As Word.Document Set wdApp = New Word.Application Set doc = wdApp.Documents.Open(FileName) doc.PrintOut wdApp.Quit False Set doc = Nothing Set wdApp = Nothing Case "tiff": Case "jpg": Case "bmp": Case "pdf": 'Via Arobat32.exe Case "dwg": 'Via ACad32 Case Else: End Select Next Atmt Next x End Sub Thanks in advance for any input on this issue. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Printing Attachment Information | LarryH | Outlook - General Queries | 6 | October 28th 08 01:11 PM |
Attachment Printing | RGA[_2_] | Outlook - General Queries | 2 | August 28th 08 03:37 PM |
Right click send to mail recipient of an TIFF | Cat bite | Outlook - General Queries | 1 | May 24th 06 06:16 AM |
printing attachment name in Word | Martin | Outlook - Using Forms | 2 | April 7th 06 10:46 AM |
How do I convert an incoming TIFF fax to a Adobe PDF? | Bob | Outlook - Installation | 1 | April 4th 06 08:41 PM |