This sounds like something you would write a small app for. Emailing from code is well covered so nothing to write about there. After that it's just a matter of parsing to some email this software.
Not an offer to write this for free but this from Excel would have us write code.
Bob
I am looking to automate a process, at least minimally. I generate a report that comes in an excel spreadsheet, and I have to email certain lines of the spreadsheet to certain people with a block of text. For example, line 2 will go to one person, lines 3-8 will go to another, lines 9-11 will go to a third, etc. There will be anywhere from 1 to hundreds of lines going to any given person, and the persons name is on each individual line. I have a manual process for this, but it will take me a week or more to make it through the 3600+ lines on this report, and I would like to get through it a little quicker if possible.
I already use a text replacement program, but it is difficult to automate some of the process this way, such as specifying a recipient based on clipboard data, etc. Heck, if there is a third party app I could use to perform automate this function, that would do.
This is in Office 2003, BTW. I have looked into mail merge, but I am not sure if this is the right approach or not.
Any ideas?
TT

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic