How's it going.Let me read of your question. Give me a minute.
How do you envision this working?
Sending the range of A1 to B45 to outlook?
This is possible with a script. If this is what you are looking for.
Yes, what version of excel are you using?
Are you familiar with VB?
what you might be able to do is create a word document for each person and link the sections of the worksheet that apply to them into the word document.
then updating the document will pull the newest data from the spreadsheet and you could then email the word document.
Another way to do it would be to create a new tab for each person and have only the relevant data for that person by just referencing the appropriate rows from the main sheet.
then you can mail each persons sheet to them
You don't have to cut and paste.
You can do it once for the word files and they will auto update if you do it right
or just use formula to make each tab for each person.
Then use the file/ send on each individual worksheet which will also auto update
The VBA is a programming language. It is nowhere near as easy to use as what I am suggesting
Here is tutorial on VBA macros. But I think it is a bit more than you want to learn for this one project