I am not a very experienced programmer, and have had trouble figuring this out on my own. I am attempting to generate an outlook email without automatically sending it, so the user of the spreadsheet must visually review the contents, then click send. The problem I'm running into mostly with reading various responses, is the sheet pretty much has to be stylized, so I don't have names or emails as column headings, they are within the content of the email. Let me provide some more info.
The recipient email would be in the fields B9:B50, and their name will be C9:C50. Each Name/Email has to generate it's own unsent email, so the user must review each individual email and then click send.
I searched and could not find a way to do this with a stylized sheet, and to create the email without sending. Thank you for the help!