email sheet or range to cell value (email address) in vba

[Ralter649]

I would like to make a macro to E-mail of ​

Sheet5​

​

or

​

Sheet5 (A:1,J:300)​

to ​

Sheet5 H5​

(an e-mail address) in vba.
Can you guide me in the right direction? I can make the macro I just don't know how to wright the code.​

 

[jtakw]

Hi,

Isn't this a duplicate post to: https://www.mrexcel.com/forum/excel-questions/1071697-email-sheet-range-cell-value-vba.html

where MARK858 gave you some advice?

Anyway, if

I can make the macro I just don't know how to wright the code.

Isn't that one and the same?

 

[Ralter649]

yes it was sorry

 

[Fluff]

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).