Printing Pages in Outlook

Hello Experts,

I've got a real nagging problem with printing in Outlook - its really hard to describle but here we go.
I have two pages to print, but when I look in print preview outlook keeps on showing three pages, even though the third page is blank. The pages have tables.
I know what you're think 'the tables have carried over into the third page but trust me the tables haven't carried over.

Can someone, please, please tell me how to deal with this???

Cheers

Carlton
cpatte7372Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

richardcardinCommented:
Any chance you could save the email as a MSG file and post it?
0
cpatte7372Author Commented:
Sure, give me a second.
0
cpatte7372Author Commented:
richardcardin

It won't let me upload msg files.

Dang!
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

cpatte7372Author Commented:
richardcardin

Do you have any other suggestions?

How about I email it to you?

Do any other experts have any suggestions?

Cheers
0
richardcardinCommented:
rename it from filename.msg to filename.msg.txt and upload. I see this work with othes.
0
cpatte7372Author Commented:
richardcardin

Here you go mate.

Hope you can help

C
New-Freedom-Template.msg.txt
0
richardcardinCommented:
I was able to download this and open it. I didn't have the same issue you did, it only printed 2 pages but it cut off the far right as it exceeded 11". Hopefully somone else can give more info. I'm out for now. Have a great weekend.
0
cpatte7372Author Commented:
quomodo

Thanks but still no one gets back to me!
0
lyonstCommented:
I have tried it also using Outlook 2007 and I only get 2 pages in the Print Preview window.. as said above it is truncated on the right hand margin also!!
0
cpatte7372Author Commented:
lyonst

Thanks for getting back to me. How is it possible that you get two pages in print preview? What are you're page settings?
0
cpatte7372Author Commented:
lyonst

I have attached another document which shows two pages in print preview when there is only one. So weird.

Its driving me crazy

two-pages.msg.txt
0
cpatte7372Author Commented:
lyonst or any EXPERT!

I have attached another copy of the one of the documents that's printing out more pages than is needed. You will notice that there isn't any text in the first and third column however print preview still shows 3 pages. I should mention that the content is contained with tables. However, I don't believe its the tables that's the problem.

Will someone please help???

Carlton
template.msg.txt
0
lyonstCommented:
Sorry, what OS (Vista, XP etc..) and Version of Outlook are you using and I will try and replicate..
0
cpatte7372Author Commented:
lyonst

XP, Outlook 2007 SP2.

I'll getting really desperate here mate. So I really hope you can help

Cheers

Carlton
0
cpatte7372Author Commented:
quomodo

OK, I'm sorry.
0
lyonstCommented:
Ok was able to replicate and fix using my version of outlook 2007 and XP..

two-pages.msg.txt (40 KB) (Possible File Type Mismatch)

The Table seems to exceed the margins of the page in print preview thus causing a blank page to be printed..

If you move your mouse to the bottom right side of the table you should be able to drag the corner of the table/frame back slightly thus reducing its size slightly and fixing the problem. Worked ok for me now using the file you uploaded..?

0
cpatte7372Author Commented:
lyonst

I will give it a go. Let you know shortly

Cheers mate.
0
lyonstCommented:
Cheers..
0
cpatte7372Author Commented:
lyonst

Would you know how to get the contents in the last column on page two to fit in the table from the attached?

Cheers
New-Freedom-Template3.msg.txt
0
lyonstCommented:
Also if you right click on the table there is a property (under row) that says..

Allow row to break across pages.. try unchecking it and see if that helps?

Also you might try unchecking the Specify Height box if it is checked on the same settings page..
0
lyonstCommented:
Yes again you will need to resize the column widths.. If you look at the ruler you will need to resize the 3 columns to be below 8" (8 inches - i.e. A4) across.. Resized it on the version you uploaded and all 3 columns now print ok.
0
lyonstCommented:
Sorry max width of 3 columns should be 8" in total..
0
cpatte7372Author Commented:
lyonst

Can you send it back to me with the amendments?

Cheers mate.
0
lyonstCommented:
Sorry will have to upload it later.. have to go for now.
0
cpatte7372Author Commented:
ok mate. give me shout when you get back
0
jjafferrCommented:
I had enough of Outlook not allowing my users to print selected pages,
so I wrote a VBA macro, which opens the email in IE, in print preview, then the user can have all the printing options, which includes printing in Landscape.

if that is an option, let me know so that I can post the code.

jaffer
0
cpatte7372Author Commented:
jaffer

You're a star. I would love to get my hands on it.

Cheers

Carlton
0
jjafferrCommented:
ok, but you will have to wait until I get to the office tomorrow :)

Because it is VBA Macro, Outlook allows you to make a button in your tool bar,
so it is easy to output the email to IE,
the code saves the email as an HTML page, in the system temporary directory, and displays it.

jaffer
0
jjafferrCommented:
Here is the Macro.
make a reference to microsoft scripting runtime

I left my testing code there too, so you can delete it if you wish.

once you have this code in place, you can make a button (icon) on the toolbar, where the users can click and get the email on the IE.

you might have to reduce the security to LOW, otherwise it will not work.

Good luck :)

jaffer

Sub Print_Page()
On Error GoTo ErrorHandler
    
    Dim att, FileName As String
    Dim web
    Dim mySelection As Object
    Dim myItem
    Dim i
    
    Set mySelection = Application.ActiveExplorer.Selection
    Set myItem = mySelection.Item(1)

    'get the attachment names
'    att = ""
'    For i = 1 To myItem.Attachments.Count
'        att = att & myItem.Attachments(i) & "; "
'    Next i
    
    'remove the last ; , if there were attachments
'    If myItem.Attachments.Count <> 0 Then
'        att = Mid(att, 1, Len(att) - 2)
'    End If
    
'    MsgBox "From: " & myItem.SenderName & vbCrLf & _
           "Sent: " & myItem.ReceivedTime & vbCrLf & _
           "To: " & myItem.To & vbCrLf & _
           "Cc: " & myItem.CC & vbCrLf & _
           "Subject: " & myItem.Subject & vbCrLf & _
           "Attachment: " & att '& vbCrLf & _

    'save to the temporary folder
    FileName = sTempFolder & "\Email.html"
    myItem.SaveAs FileName, olHTML

    'add the subject to the HTML file
    Open FileName For Append As #1
        Print #1, vbCrLf & "<title>" & myItem.Subject & "</title>"
    Close #1
    
'<title>Outlook Add-in Commandbar Problems</title>
'Exit Sub
    Set web = CreateObject("InternetExplorer.Application")
    web.Visible = True
    web.Navigate FileName
       
    'wait until the web page fully loads
    While web.ReadyState < READYSTATE_COMPLETE
        DoEvents
    Wend
    
         
    'unfortunately, the above wait until page is complete, does not work
    'so we have to introduce a wait/pause in code until the page fully loads
    Dim PauseTime, Start
    
    PauseTime = 2    ' Set pause duration.
    Start = Timer    ' Set start time.
    Do While Timer < Start + PauseTime
        DoEvents    ' Yield to other processes.
    Loop

    'show the print preview with size shrink to fit
    OLECMDID_PRINTPREVIEW = 7
    web.ExecWB OLECMDID_PRINTPREVIEW, OLECMDEXECOPT_DONTPROMPTUSER


    'print dialog using SendKeys
'     SendKeys "%" & "(FP)", False


Exit Sub
ErrorHandler:
    MsgBox "There are no items to display."

End Sub

Function sTempFolder() As String

    'make a reference to microsoft scripting runtime
    
    Dim oFS As FileSystemObject
    
    Set oFS = New FileSystemObject

    ' Temporary Folder Path
    sTempFolder = oFS.GetSpecialFolder(TemporaryFolder)
    
End Function

Open in new window

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
cpatte7372Author Commented:
Great
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Outlook

From novice to tech pro — start learning today.