Hi I am creating emails using VBA in Excel. For the body of the email I am taking the value of a cell. Example in D2 i have the following message, however once the email is created by VBA the entire message shows in one single line. How can I split ( break the line by comma)?
Hi Stacie,
I hope you are......
HTML Code:
If the email has a HTML body then the logic would be something like:
If it is not HTML then maybe the below logic would work:
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by CheeseSandwich; 11-03-2022 at 10:25 AM.
If things don't change they stay the same
Thank you, how would that fit in my code? Can you help? It is HTML
I can't see your code for some reason so difficult to say. Can you see the code in your first post?
I do not see either, here we go again
Please Login or Register to view this content.
I see it now.
Please Login or Register to view this content.
That worked great thanks however I want to break the line each time I click Enter, what change is needed?
Do you mean whne you click ALT+Enter to go to new line within a cell?
In the OP it stated "( break the line by comma)" so i assumed the line break was going to be done with a comma within the cell where the body text resides.
You are correct, I would not have said by comma because in each comma the lines break. I mean click ALT+Enter to go to new line within the same cell.
Maybe this:
Please Login or Register to view this content.
Thank you that worked
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks