Avatar of Gordon Hughes
Gordon Hughes
Flag for United Kingdom of Great Britain and Northern Ireland 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
Microsoft ExcelMicrosoft WordMicrosoft Office

Avatar of undefined
Last Comment
Gordon Hughes

8/22/2022 - Mon
Rob Henson

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

ASKER CERTIFIED SOLUTION
Kesavan Jeganarayanan

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
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
Your help has saved me hundreds of hours of internet surfing.
fblack61
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
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Kesavan Jeganarayanan

Do you have outlook as default mail application? 

Gordon Hughes

ASKER
Hi Kesavan

I am sure I do, how do I check?
Gordon
Kesavan Jeganarayanan

Click windows key and type default apps, check you have outlook. 

All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
Gordon Hughes

ASKER
Hi Kesavan
Ok was not set, have now set it to outlook
But still not sending emails!!
Gordon
Gordon Hughes

ASKER
Hi Kesavan
I have tried it on another PC making sure the default mail is outlook and it works
Gordon
Gordon Hughes

ASKER
Thanks all of you for your help
Gordon
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.