Hey guys and girls,
My Access email macro is looping through and launching duplicate email windows until I tell manually stop it. Can't figure out why it is looping, any help would be appreciated. Database that has several forms that all link to a navigation from.
Please Login or Register to view this content.
This is a guess, but I claim my cigar right now. This sub is fired by a button. The button has focus because you clicked it.
This line presses the button again (and again, ad infinitum).
Avoid Sendkeys if you can. Its like typing with the screen off.Please Login or Register to view this content.
Frob first, tweak later
That appears to have fixed the issue. Any recommendations on how to may a gap between the body of the email and the signature since Enter will not work?
Tested
Please Login or Register to view this content.
Last edited by Neil_; 10-12-2016 at 04:51 PM. Reason: Tested and working
Oh, and if there is any special formatting in the signature use .HTMLBody instead of .Body
Thank you for helping me. When using this code even after switching to HTML Body it does not keep the special formats and strings the signature together with the body. Need to find a way to have the body inserted, then create a space and insert signature. Any ideas?
Worked fine for me. You need to use HTML "<br>" to insert a break as you are pasting into HTML. did you replace both .body in the code?
Please Login or Register to view this content.
Ah, Missed that part. Thank you so much, works perfectly!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks