Send Same Message Three Times to Different Lists

[Rishek]

So every day, I create a message which I send to myself and BCC to a large number of recipients in three separate lists. I know that I'd be better off with a mail merge, but I can't install any add ins and the message has two attachments, making things a little bit more complex.

I would like a macro to address the message to myself in the TO field, BCC my first list "List 1", send it, then resend it first with the BCC as "List 2" and then a third time with the BCC as "List 3."

Thoughts?

[gmayor]

A company that will not allow you to install add-ins which would do the job - e.g. http://www.gmayor.com/ManyToOne.htm but which will allow inexperienced programmers loose with VBA on their systems is frankly crazy. While what you ask is probably feasible, mail merge would be the better approach. If your company expects you to do the job they ask of you then they should provide the tools to do it. You need to speak to management.

[Rishek]

Welcome to non-profit.

And thanks for the ManyToOne (which is indeed the solution). I'll go to our sysadmin about it again and see if I can make a case.

(I actually like both the job and the company a great deal; arts admin is just not exactly technology forward).