[MikeReich]

Although decently experience with excel, I am quite new with VBA and I cannot "record" this macro, so any help writing this in VBA is much appreciated.

1) I need to create a macro that will take a number that is entered into a cell, and upon hitting a button in the excel sheet create an email where the subject line is the number that was in that original cell.

1b)I would like to do this without changing the name of the excel file though, or at least have another macro that resets the file to its original name.

2) Also, if possible, the same macro/vba as above, only with two cells, a number in one and a name in the other, which then shows up as "Number-Name" as the subject line in the email.

Thanks to anyone that can help - Mike

[OBP]

Mike, this topic has been covered a few times in the past and should provide all the VBA code you need.
Have a look at these
http://forums.techguy.org/business-a...ata-excel.html
http://forums.techguy.org/business-a...tion-list.html
http://forums.techguy.org/business-a...ail-excel.html
http://forums.techguy.org/business-a...ail-excel.html

[MikeReich]

OBP
I am not sure if its my lack of ability or not, but the links you sent only take me to the techguy main page. I looked around on the site, and there is something about your ellipsis(s) that they are not showing the part of the link they replace, as I've seen with other links. Can you give it another shot?

- Mike

[OBP]

Mike, it is not you I forgot that the forum doesn't like copied links, try these instead
http://forums.techguy.org/business-a...ata-excel.html
http://forums.techguy.org/business-a...tion-list.html
http://forums.techguy.org/business-a...ail-excel.html
http://forums.techguy.org/business-a...ail-excel.html

[slurpee55]

Originally Posted by OBP

Mike, it is not you I forgot that the forum doesn't like copied links, try these instead
http://forums.techguy.org/business-a...ata-excel.html
http://forums.techguy.org/business-a...tion-list.html
http://forums.techguy.org/business-a...ail-excel.html
http://forums.techguy.org/business-a...ail-excel.html

Hmm, I didn't know that...thanks OBP. I may have to go fix an answer I gave earlier.

[OBP]

slurpee, it is Ok to copy the url link, what the forum doesn't seem to like is the Copying of a Copied Link, which is what I did as I had just posted those links afew hours before. (being Efficient? Lazy?)

[slurpee55]

I found out my other post was okay, so I must have done something right...oh, I would say efficient, except it doesn't work!