I created a VBA which will send a sheet of a excelfile to a fixed email address in the VBA code. That is nice, but what I really want is the VBA to look at a particular cell in the activesheet (M2) to pick up the email address from there. Below is a part of the VBA code. In the section .To = "[email protected]" I want a code which will pick up the email address. Does anyone know which code I can use??
Please Login or Register to view this content.
Last edited by TNT Innight; 02-19-2015 at 08:13 AM. Reason: I did not use the Code wrapping
Try this. I use the code ActiveSheet.Range("B5") to reference a cell in my emails, that way I can change it. Let me know if it works for you.
Please Login or Register to view this content.
Yeah! Thanks, that was very helpfull.
Just a heads up that will use M2 from whatever sheet you have open in excel. If you dont want to deal with that you can use this code:
ActiveWorkbook.Sheets("Rent Tracker").Range("M2")
This will make it so it will use M2 on the specified sheet mine is "Rent Tracker" Note that this is case sensitive. So your code will look like this: Just change the sheet name.
Please Login or Register to view this content.
This is even better. I am beginning to understand VBA codes better now. Thank you
Glad to help. Please edit your first post and ad the prescript of Solved on there.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks