Macro that auto generates Email within Excel

For the spacing, try this:

    Msg = "Good morning,  " & Chr(10) & _
       "Please find today's forecast for Friday, May 07, 2010 attached. " & Chr(10) & _
       "Thank you," & Chr(10) & _
       "FRC Treasury Team"

I'm not sure about the colors, but I'm guessing that the original file was created in Excel using a custom mapping for color indices, and when the new file is created is uses the default color indices. But I have not seen this before so I'm not sure.