Nevermind - figured it out. Put a Wait before the set mypdfApplication.Wait TimeSerial(Hour(Now()), Minute(Now()), Second(Now()) + 2)
seems to give it more time on the second run....
oh well it works.
Help?
Private Sub MakeMeaPDF(ws As Worksheet)
Dim PSFileName As String, SavePath As String, PDFFileName As String, FileName As String
Dim MySheet As Worksheet
Dim myPDF As PdfDistiller
If Sheet1.Range("A1") = False Or Sheet1.Range("A1") = "" Then myBrowse
If Sheet1.Range("A1") = False Or...
you don't have the preview pane on in the outbox, do you?
are you able to download mail?
are you getting any error messages? when you try and delete the message? What happens when you shut Outlook down? are you able to open the message?
Tracy
www.TheOfficeExperts.com
That is the way the program works - ms says they do it that way so you don't get the same message over and over again.
I'm looking for a good forwarding tool.
Tracy
www.TheOfficeExperts.com
how long have you given your Outlook to send? depending on your connection, it could take a while - that's a good size attachment for some systems
Tracy
www.TheOfficeExperts.com
I saw that too.. but I figured since he's been changing the name in the workbook, tried different forms, etc, that that wasn't the problem.
I'll be SO embarassed if it is!
Tracy
www.TheOfficeExperts.com
sorry, I don't use them - found them at slipstick.com
If someone knew outlook programming, they could probably write a script to delete attachments...you could attach the script with a rule. Sorry - I don't do outlook vba :-(
tho, I can see such a program being popular.
Tracy...
Not within Outlook - 3rd part programs do exist that can help. Two I found:
http://www.madsolutions.com/AE/Main.htm
http://www.comaxis.com/detach.htm
Tracy
www.TheOfficeExperts.com
and you're 100% that its the form call that's causing the problem and not something within the form?
can you send me the workbook?
Tracy
www.TheOfficeExperts.com
or you can open the distribution list, select Forward from the Actions menu, forward it to who you want. When they get it, all they have to do is drag it to their contacts list.
Tracy
www.TheOfficeExperts.com
Outlook uses its RTF mail format for sending appointments. Sounds like something (the server?) is converting that rtf to plain text.
Couple of tests:
1. have the user send himself an appointment
2. send a normal rtf message to someone and see if it converts.
to verify that a plain text message...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.