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!

Recent content by Trumper1

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

Part and Inventory Search

Back
Top