VBA to set up draft emails

Hi.

I've got 50+ emails to send each week which I'd like to automate them rather than having to go into Outlook and open the previous versions and resend them after making a few adjustments.

Is it possible to set up a spreadsheet with the recipients names in, the standard wording to be included in the email and then for it to save the emails in my draft email folder to enable me to attach files to the emails?

Not all the emails are identical, so I'd like it to look at a standard wording field in the spreadsheet for all emails except where sub-standard wording is included in a seperate cell and for that to be used instead.

Do I have to add the recipients email addresses if they are included in our work address book or will the name suffice for it to the "check name" in Outlook once it's saved/ready to send?

I'm presuming a VBA code could do all this, but would appreciate it if you've any comments.

Thanks.

1--I started messing with an email list in excel, but stopped and can't find my code, perhaps someone else has that info.

2--What i've done in the past is to create a mailing list in outlook, and call that list in the code to send out a nightly email. That way you can modify the group list instead of having to go back into the code.

Here's what's currently working in my nightly code:

Please Login or Register  to view this content.

This works great. I have this tied to a button so its sent out as soon as the button is pressed.

ChrisCom - thanks, but I don't think it's exactly what I need. Each recipient of the emails will receive a slightly different version as the email will be sent to various divisional colleagues with their results on.

Hi Tinbendr. The layout of the spreadsheet is what I envisaged. I can't see any coding though? I want the emails to be saved as drafts as I'll need to add specific attachments to each.

Thanks Tinbendr I can work with that, much appreciated!