Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
copy range of cells from excel and paste them into email body
- Thread starter Gaz1000
- Start date
- Thread starter
- #2
"Although I was hoping not as text, because I would prefer not to be able to change the cell values once they are in the email."
OK forget about that first bit - what about this bit?
"how I can copy a range of cells from an excel worksheet and then paste them into an outlook email body"
Worksheets(UserName).Activate
Range("B" & startrow & ":" & "C" & endrow).Select
Selection.Copy
I'm using this to copy the cells, now I just need to find out how to paste it into email body. Anyone???
OK forget about that first bit - what about this bit?
"how I can copy a range of cells from an excel worksheet and then paste them into an outlook email body"
Worksheets(UserName).Activate
Range("B" & startrow & ":" & "C" & endrow).Select
Selection.Copy
I'm using this to copy the cells, now I just need to find out how to paste it into email body. Anyone???
- Status
Similar threads
- Locked
- Question
