VBA to put Cells as Text in E-mail

[vertibrae]

Hi,

I'm hoping somebody can help me with this issue. I currently have inputs in cells A11:A27 as text and I'd like to send create a VBA code to automate the process copy & pasting this into an e-mail and sending it out. (Daily Process)

E-mail subject is always in A11, Body is A13:aA7, and To: and CC: is A30 and A31 respectively. I've taken a look at some other threads but haven't been able to find an answer.

Many thanks,
Vertibrae

[vertibrae]

I use Outlook for e-mail

[vertibrae]

bump please and ty