K
Kurt
I am creating a Macro to Automate functions with email. It keeps
missing some keys ECT...does anyone have ideas to clean my code up a
bit and make it more functional...I am using Office 2003 and the Focus
starts in the From field of an email...
"#" is replacement text for Privacy...
Public Sub AutoEmail()
SendKeys "####@####.###", True
SendKeys "{Tab}", True
SendKeys "{Tab}", True
SendKeys "{Tab}", True
SendKeys "Support_log@#####.###", True
SendKeys "{Tab}", True
SendKeys "{PGDN}", True
SendKeys " ", True
SendKeys "21002", True
SendKeys "{Tab}", True
SendKeys "{PGUP}", True
SendKeys " ", True
Selection.TypeText Text:="Hello,"
Selection.TypeParagraph
Selection.TypeText Text:="Thank you for contacting ##### ######
######. "
Selection.TypeParagraph
Selection.TypeText Text:="If you have any further questions or
issues, please reply to this email."
SendKeys "{UP}"
End Sub
missing some keys ECT...does anyone have ideas to clean my code up a
bit and make it more functional...I am using Office 2003 and the Focus
starts in the From field of an email...
"#" is replacement text for Privacy...
Public Sub AutoEmail()
SendKeys "####@####.###", True
SendKeys "{Tab}", True
SendKeys "{Tab}", True
SendKeys "{Tab}", True
SendKeys "Support_log@#####.###", True
SendKeys "{Tab}", True
SendKeys "{PGDN}", True
SendKeys " ", True
SendKeys "21002", True
SendKeys "{Tab}", True
SendKeys "{PGUP}", True
SendKeys " ", True
Selection.TypeText Text:="Hello,"
Selection.TypeParagraph
Selection.TypeText Text:="Thank you for contacting ##### ######
######. "
Selection.TypeParagraph
Selection.TypeText Text:="If you have any further questions or
issues, please reply to this email."
SendKeys "{UP}"
End Sub