asked on

Help with merging and emailing data

Hi
I have an excel sheet with Names, email and passwords
I want to send an email to each individual on the list with their password, also with some text explaining what it is used for.
I guess I could use word and merge the excel sheet data
But don't know how I can get it to send separate emails to the individual
Any ideas or guidance please

Gordon

Rob Henson

Mail Merge in Word has option to send email rather than letter

Bill Prew

Here are a few walkthroughs / examples...

»bp

ASKER CERTIFIED SOLUTION

Kesavan Jeganarayanan

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Gordon Hughes

ASKER

Hi Kesavan

I managed to get the word document with the excel links ok
Then at stage 6 it says Electronic Mail
So select that and I get the Merge to email box as you have shown above
It says To Email which is correct
Format HTML

So I select Ok
Nothing happens, no emails sent

Any ideas
Gordon

Gordon Hughes

ASKER

Hi Kesavan

If I select the preview Results Nothing happens

Gordon Hughes

ASKER

Hi Kesavan
OK if I preview results it shows the first name etc
Gordon

Gordon Hughes

ASKER

Hi Kesavan
Do I need to say send, wherever the command is

Kesavan Jeganarayanan

Do you have outlook as default mail application?

Gordon Hughes