Access email works sometime not others

Question

Access email works sometime not others

Mary Stroup 1

Code to send an email from Access. Works sometimes, not others - with no code change. Sometimes it runs the code and then throws an error, after email have been sent successfully. I am not sure what the problem can be. It may be late binding? which i do not have a grasp of. No error message received. Just the whole block of html code is highlighted. Offending code is below.

strbody = "<html><head><title>2022 GIRLFRIEND GATHERING</title><style>body{margin-left: 20%;margin-right: 20%;" & _
"borders: 2px dotted black;;padding: 10px 10px 10px 10px;font-family: sans-serif;}</style></head>" & _
"<body>" & _
"Dear " & rs!First & "," & _
"We are very pleased that you will be joining us for our 2022 Girlfriend Gathering. This email is to confirm the receipt of your registration." & _
" Please let us know if you see any errors." & _
"Name: " & rs!First & " " & rs!Last & " Address: " & rs!Address & " " & rs!City & ", " & rs!St & " " & rs!Zip & "" & _
"Phone number: " & rs!Phone & " Email: " & rs!Email & " Emergency Contact: " & rs!EM_Contact & " Emergency Phone: " & rs!EM_Phone & "" & _
"Church: " & rs!Church & "" & _
"Attending: " & rs!Attending & " Session Choices: 1) " & rs!First_Choice & " 2) " & rs!Second_Choice & " 3) " & rs!Third_Choice & "" & _
"Food Selection: " & rs!Entree & " " & rs!Sandwich & " " & rs!Salad & " " & rs!Dressing & " " & rs!Dessert & " " & rs!Side & "" & _
" When you arrive at Chapel of the Cross, please go in the main door. You will be met by a member of the Registration Committee and will receive a bag with information as well as a nametag." & _
" We are very glad you are taking this opportunity to meet with other women for fellowship, food, and fun, as we learn about Worrying Less and Praying More." & _
"Blessings, The Registration Committee</body></html>"

Access email works sometime not others

Activity