We help IT Professionals succeed at work.

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
Comment
Watch Question

Rob HensonFinance Analyst
CERTIFIED EXPERT

Commented:
Mail Merge in Word has option to send email rather than letter
Bill PrewTest your restores, not your backups...
CERTIFIED EXPERT
Expert of the Year 2019
Top Expert 2016

Commented:
IT Consultant
CERTIFIED EXPERT
Commented:

You can use Excel File as Recipient, and use the Word Mail merging option to send individual email. 

See my pictures. 

Also click this link for reference:

https://support.office.com/en-us/article/mail-merge-using-an-excel-spreadsheet-858c7d7f-5cc0-4ba1-9a7b-0a948fa3d7d3

  


Gordon HughesDirector

Author

Commented:
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 HughesDirector

Author

Commented:
Hi Kesavan

If I select the preview Results Nothing happens
Gordon HughesDirector

Author

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

Author

Commented:
Hi Kesavan
Do I need to say send, wherever the command is
Kesavan JeganarayananIT Consultant
CERTIFIED EXPERT

Commented:

Do you have outlook as default mail application? 

Gordon HughesDirector

Author

Commented:
Hi Kesavan

I am sure I do, how do I check?
Gordon
Kesavan JeganarayananIT Consultant
CERTIFIED EXPERT

Commented:

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

Gordon HughesDirector

Author

Commented:
Hi Kesavan
Ok was not set, have now set it to outlook
But still not sending emails!!
Gordon
Gordon HughesDirector

Author

Commented:
Hi Kesavan
I have tried it on another PC making sure the default mail is outlook and it works
Gordon
Gordon HughesDirector

Author

Commented:
Thanks all of you for your help
Gordon