I was trying to come up with ways to streamline some of our reporting at work. We currently send out a report 3 times a day. The data gets updated in a spreadsheet. We then copy certain info from the spreadsheet into lotus notes where the body of the email has tabs. Each tab gets a different peice of information from the report. Is there a way for VBA to have an excel macro that copies the cell range that I want and posts it into lotus notes? Would it make it easy to do if I already had lotus notes open and the New Memo open so all it needed to do was copy the data from certaing ranges into the open New Memo?