Recent content by rlmOC

Hi Caution, By setting the Error trapping to break on all errors, Once the Fax button was clicked, I received the following: Run Time error 429 ActiveX component can't create object The line of code highlighted is: Set appOutlook = Get Object(, "Outlook.Application") I hope this gets you...

Yes I am

Hi Caution, Well if anything, it sped up the time it takes for the msgbox to pop-up. (lol) It is taking about 2-3 seconds and then the msgbox pops up. Once I click OK, I am taken to Outlook where the fax is attached. rlmOC

Hey Caution, Looks like we need to throw a brick, same result after the DoEvents. Hope you have a great weekend. rlmOC

Hi Caution, Actually, you may be dead on with your assessment. After the Msgbox appeared and I clicked OK, I was taken to Outlook with the Fax attachment. Could you help me with the DoEvents. I am a beginner and I am not quite sure what to do here. Thanks, rlmOC

Hi Caution, The message box immediately pops up. Please see my code below: Sub fax() ' Sheets("quote").Range("D9:K9").Select ActiveSheet.Unprotect Password:="rsx" Sheets("quote").Range("A1:AD55").Select Application.ActivePrinter = "FAXmaker on Ne00:"...

Hey Caution, Thanks for the reply, I will give this a try a little later when everyone is off the system. Quick question though, I don't see where I would automatically be sending the fax. Not that it is a big deal, my main concern was populating the TO: field. Is the Send included in here...

Hi, I currently have a command button on my spreadsheet that will copy a specified range and automatically attach it using Faxmaker, the user is then taken to the Outlook screen where they currently have to type in [Fax:18889999999,18889999999] then click the send button in Outlook. I would...

Hi, I currently have a command button on my spreadsheet that will copy a specified range and automatically attach it using Faxmaker, the user is then taken to the Outlook screen where they currently have to type in [Fax:18889999999,18889999999] then click the send button in Outlook. I would...