The .to should work for hard coding in the address.
The subject should work as well. The only thing may be that you need to get that value in Range("H152") when the original sheet is still open. You can do something like this near when the stFilename is set to A1:
Dim stSubject as String stSubject = Range("H152").value
Some people volunteer in soup kitchens or hospitals. I choose to make the world better by trying to help you with Excel. We're all learning.
<---Click * Add Reputation for all helpful comments. It's like giving a smile.
Forum Rules: How to mark your post [Solved] and have a happier, Excel enriched life.
My Apologies for the repetitive images....my badOriginally Posted by nigelbloomy
The .to should work for hard coding in the address.
The subject should work as well. The only thing may be that you need to get that value in Range("H152") when the original sheet is still open. You can do something like this near when the stFilename is set to A1:
Dim stSubject as String stSubject = Range("H152").value
I modified the email code as suggested but it is till coming up empty in the SEND TO, and SUBJECT LINE part of the email...? By all accounts it should work but not sure why it isnt
THANKS SO MUCH FOR YOUR PATIENCE WITH ME
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks