Help with in-EMAIL TXT formatting

Hello Excel experts. Am needing assistance with a quick modification of an EMAIL code I got from this forum that i modified to allow for IN-BODY text within the email itself (plus the original attachment in original code)

Here is the code below

Please Login or Register  to view this content.

The Code Works fine but below image shoes the result:

FMSEmailImagev1.jpg

My dilema is that on the 4th line "Time of Incident ; 0.521527777777778" I want it to read "Time of Incident ; 12.31" instead.

I tried the below code modification but kept getting "FALSE" as only in-body text in email...please help!

Please Login or Register  to view this content.

Thanks

Or perhaps the solution could be modifying the code to have it in an HTML format? (just based on what I am reading online about in-body email txt??)

Hi Harry,

Easiest question first. For date and time formatting see the bottom of the following link:
http://www.globaliconnect.com/excel/...=79&Itemid=475

The following is an excerpt of your code that contains date and time formatting:

Please Login or Register  to view this content.

Lewis

Since I don't use Outlook, the answer to your more difficult question could be problematic.

See post #3 and the files associated with that post in the following link: http://www.excelforum.com/excel-prog...cel-range.html

The sample file attempts to create User choice of either text or HTML as the body of an Outlook e-mail. I hope this helps.

Lewis

thanks LJMetzger. It worked beautifully.
Also thanks for the links. Learned a lot!