I'm VERY new to VB, thanks to Rod!
I had a macro that used the SendObject command, to stick a report into an email. I have converted this macro to a module. I don't really know how to get modules in to VB. By that I mean when I am select an object in a form and choose to Build Event, I don't know how to find the modules, so at the moment I am cutting and pasting the module into the VB buidl event window and editing accordingly!!

The problem I have with the VB code is that I cannot put a Carriage Return in the message body text, so the whole thing comes out on one line.

Any clues?

Thanks, Matt