Email Sent From Access - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Email Sent From Access

Kim Boren

9 months ago

Hello,

I have successfully been able to create and send an email from Access. However, there are no line spaces even though I have them in the email body. Example: "Please feal free to send the information via email." & vbCrLf & vbCrLf & _
I display the email before sending and in the body of the email there are no line spaces. Can someone help me understand why?

Thanks Kim

	Kevin Robertson @Reply 9 months ago
Is it an HTML email in which case you need "br" or "p" `"Please feal free to send the information via email.br br" & _` Enclose br and p in angle brackets (<>). Try using vbNewLine instead. Another option `"Please feel free to send the information via email." & Chr(13) & Chr(10) & Chr(13) & Chr(10) & _`

	Kim Boren OP @Reply 9 months ago
Kevin, Thank you. I will try your suggestions. I thought I was sending the email, however with further testing I have found out that I am not sending the email. So I will be working on that as well. Thanks again, Kim

	Kim Boren OP @Reply 9 months ago
Kevin, The .br br" & _ works great. Yes it is HTML format. Thanks again, Kim

	Kim Boren OP @Reply 9 months ago
Hello, This is the email I want to send when I click Command16; see attachment. The email goes to outlook, I click the send button in outlook and it seems to send, but it is not. Perhaps you can help me understand why? Kim

	Kim Boren OP @Reply 9 months ago

	Richard Rost @Reply 9 months ago
Yeah, if you're using HTML, then use the BR or better yet a P tag.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View