Nifty Email Generator / User Database Interface?

I've been trying to modify this code in several ways but I can't figure it out, I'd like to

a) use different sections for the email generation where the email address/surname/forename/location are in my user database

b) have a popup screen appear for the body of the email text, I don't like the idea of my secretary having to go into the code to change the text

c) another popup box requesting an email identifier that will set a 'flag' in the Email Information column to show they've had that email and (this may be ambitious) to record the body of the email text somewhere that I can review so there's a record of what's been sent out

This is the code

Dim oXlWkBk As Excel.Workbook ' Excel Work Book Object
Dim oOLApp As Outlook.Application
Dim oOLMail As MailItem
Dim lRow As Long
Dim olMailItem

[code]....