Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: rlmOC
  • Order by date
  1. rlmOC

    VBA code for Faxmaker

    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...
  2. rlmOC

    VBA code for Faxmaker

    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
  3. rlmOC

    VBA code for Faxmaker

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

    VBA code for Faxmaker

    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
  5. rlmOC

    VBA code for Faxmaker

    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:"...
  6. rlmOC

    VBA code for Faxmaker

    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...
  7. rlmOC

    VBA code for Faxmaker

    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...
  8. rlmOC

    Excel VBA Help...

    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...

Part and Inventory Search

Back
Top