I'm using Excel to email people using Lotus Notes. For the messagebody, i am using a string,
Dim Body as String
Body = "Hi there , how are you today"
however, what i need to pass as the messagebody, is a range of another sheet.
I've tried using 'As Range' but that generates an error.
If possible i'd like to keep all the formatting, colors etc. but thats not top priority.
Dim Body as String
Body = "Hi there , how are you today"
however, what i need to pass as the messagebody, is a range of another sheet.
I've tried using 'As Range' but that generates an error.
If possible i'd like to keep all the formatting, colors etc. but thats not top priority.