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!

Register Log in
  • Congratulations derfloh 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: *

  1. Trumper1

    Auto emailing

    The answer to this is well covered in faq 707-4334 although I am still having some minor problems with it.
  2. Trumper1

    Send mail from Excel without prompts - problem

    I have carried out the process described in faq 707-4334 to send an e-mail from Excel without prompts. In about 1 in 10 (sometimes up to 1 in 20) occasions the e-mail fails to send and leaves an unsent mailitem on the desktop which is rather annoying and not especially robust. Does anybody...
  3. Trumper1

    Send an e-mail without prompts - problem

    FYI This is the relevant code: ElseIf [h28] <> "" Then With objMail .To = "Middle Office" .Subject = "Trade: " & [h28] & " " & [d7] & " " & [h31] .Body = "" .Display End With End If SendKeys "%{s}", True Set objMail = Nothing
  4. Trumper1

    Send an e-mail without prompts - problem

    I have carried out the process described in faq 707-4334 to send an e-mail from Excel without prompts. In about 1 in 10 (sometimes up to 1 in 20) occasions the e-mail fails to send and leaves an unsent mailitem on the desktop which is rather annoying and not especially robust. Does anybody...

Part and Inventory Search

Back
Top