Link to home
Get AccessLog in
Avatar of Gordon Hughes
Gordon HughesFlag 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
Avatar of Rob Henson
Rob Henson
Flag of United Kingdom of Great Britain and Northern Ireland image

Mail Merge in Word has option to send email rather than letter
ASKER CERTIFIED SOLUTION
Avatar of Kesavan Jeganarayanan
Kesavan Jeganarayanan
Flag of Singapore image

Link to home
membership
This content is only available to members.
To access this content, you must be a member of Experts Exchange.
Get Access
Avatar of 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
Hi Kesavan

If I select the preview Results Nothing happens
Hi Kesavan
OK if I preview results it shows the first name etc
Gordon
Hi Kesavan
Do I need to say send, wherever the command is

Do you have outlook as default mail application? 

Hi Kesavan

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

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

User generated image

Hi Kesavan
Ok was not set, have now set it to outlook
But still not sending emails!!
Gordon
Hi Kesavan
I have tried it on another PC making sure the default mail is outlook and it works
Gordon
Thanks all of you for your help
Gordon