I need some help... I created a spreadsheet that allows people to open the spread sheet up and entering in their daily hours and status.
For example
IN Cell A1 would be 8
IN Cell A2 would be their status like "Helped move shipment to warehouse"
In Cell A3 would be a continuation of their above status like "Shipment was for Macy's"

Then I use CONCATENATE command in a different cell like A4 and combine all those cell's.
I repeat this for everyday of the week. Sunday (A4)- Saturday(A10).

Everything is working fine.

Now... I want to e-mail theirs status.
I'm ok with it mailing it daily BUT i want it to e-mail weekly and I'm running into an issue when I use the Mailto command and concatenate all the cells for everyday of the week(A4-A10).
I've been looking into this issue and I think I'm getting stopped by the 255 character limit because when I enter in the command I get a #VALUE in the cell... if I remove some of the weekdays cells from the command and maybe say I only put Sun-Tuesday in the e-mail im ok.

I want to be able to send the full weeks status in one e-mail... Is this possible?

I was thinking maybe a macro that could copy a range of cells and then use the mailto command to launch the e-mail app (lotus) then paste the TO:, SUbject, and Week status.

but like i said before ... it keeps failing

This is the command I'm using to try and link all cells together...="Mailto: "&$AW$6&"?Subject="&$AW$5&"&Body="&A4&A5&A6&A7&A8&A9&A10
then I create another cell with a Hyperlink to the above command (Cell). That's when I get a #VALUE

Sorry if I'm not describing what I'm trying to do clearly...

Anyone got any ideas or suggestions?