Email Mail Merge Help Please!

Sammy_Girl

Hi All,

Please can someone help me. I'm at work trying to send a mail merge via email. I want to send an email to 20 email addresses - but I don't want "undisclosed recipients" in the To field and everyone's addresses in the BCC field. I want to be able to send a personalised message but without having to send it 20 times. I want the To field to read their display name not undisclosed recipients.

I have been looking online for ages now and all I can find is the "Undisclosed Recipients" and BCC advice.

Please can someone help because I'm getting really cross with this now lol.

Many thanks

isofa

Best route (if you are technical) is write a quick database/script in Access (VBA) or FileMaker (Filemaker scripting) to do this, then script Outlook to create each e-mail, enter the To address, put in the subject and content, send and repeat.

Outlook has security to prevent malware from sending multiple batches, so you'll need to sign or authorise your connection from the database to Outlook.

You should also be able to do this just using Outlook looking at a table or list of email addresses, but in both cases you'll need to be savvy with VBA programming.

Unless of course someone knows of a free tool to do this...

Else send it once to the first person, then open it from Sent Items, send again, change the recipient, tedious but will get it done in 5 minutes!

Sammy_Girl

Thanks Isofa,

Unfortunately I am not that technically minded lol.

I used to do it your other way - ie go into sent and change the names. But I was hoping for a quicker, lazier way!!