LinkBack URL
About LinkBacks
Instead of
You wanted to put some range values in e-mail body?
.Body = "Hi. Please find attached my ad hoc request form."
So you also need to edit this range and set what you trying to insert:
Set rng = Sheets("Sheet1").Range("A41:A62")
Instead of
You wanted to put some range values in e-mail body?.Body = "Hi. Please find attached my ad hoc request form."
So you also need to edit this range and set what you trying to insert:
Set rng = Sheets("Sheet1").Range("A41:A62")
Never use Merged Cells in Excel
Hi. Yes I want to include some range from one of my sheets in the body of the email in addition to the "Hi please find attached my ad hoc request form"Originally Posted by zbor
Instead of
You wanted to put some range values in e-mail body?.Body = "Hi. Please find attached my ad hoc request form."
So you also need to edit this range and set what you trying to insert:
Set rng = Sheets("Sheet1").Range("A41:A62")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks