Excel macros

One-Button Mass eMailer

Excel Button

One-button wonder

When she showed me the steps to email-merge, I got dizzy just watching. Click this, then this, then this… Worse yet, she couldn’t get it to work. Another I.T. guy had set it up for her and it had worked for him.

Having created an email button as part of another project, I thought I would take a crack at it using Excel – if nothing else, to relieve her agony of the button-merry-go-round, or worse yet, sending each email by hand. Each thousand would take her hour and a half, which will guarantee her carpal tunnel syndrome by the time she was done.

In no time – so to speak – I got it working. The operation is simplified to just one button: Send.

Advertisements