Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: email merging using Excel as a data source

27 May 2014   #1

Windows 7 Home Premium 64bit
email merging using Excel as a data source

I have WIN 7 Home Premium (service pack 1) 64-bit. I have several email addresses including gmail & hotmail and I use Windows Live Mail version 2012. I do not have Outlook.
I have been asked to do some email merging for a club I belong to. The data source is an Excel spread sheet with names and email addresses and other data. I have carefully studied what must be done and all goes well when I send emails to people who are listed in the contacts section of my WLM. But many of the members listed in the table are not in my contacts list so the Word mailmerge system stops when it gets to someone not listed. I am fairly sure this is the reason because I have experimented with an address in and not in my contacts list.
Should I export everyone from the Excel table to a csv file and then import it into my contacts list or does anyone know a better and neater way?

My System SpecsSystem Spec
27 May 2014   #2

Windows 7 Home Premium 64 bit sp1

This MS website may help you.

Importing Contacts csv file into Windows Live Mail - Microsoft Community

The alternative is do it manually, which is probably the easiest if there are not too many.
My System SpecsSystem Spec

 email merging using Excel as a data source

Thread Tools

Similar help and support threads
Thread Forum
Outlook 2003: email source downloaded via pop3
Hello, I use Outlook 2003 with SP3 (11.8169.8172) on a Windows 7 Ultimate x64 SP1 (6.1.7601 Service Pack 1 Build 7601) since yesterday. OS is up to date, nothing more to download in Windows Update at this moment. Outlook downloads via POP3 mails from a gmail account. I have the issue that,...
Microsoft Office
No DSN in ODBC Data Source Admin
I have a new HP 6200 small form factor that came pre-installed with Windows 7 64bit. I installed our corporate copy of MS Office Pro 2003 and then installed UPS Worldship 2011, which requires an ODBC to connect to our Access database. When I go into the ODBC to set up the connection under...
Microsoft Office
view source of an email which I am composing in WLM?
Outlook Express had a tab to go from "normal" to "view source" of an email which I am composing. That tab is gone in Windows Live Mail. Is there any way to get into the source?
Browsers & Mail
Where are Data source Names (DSN's) stored?
DSN's were here (HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\) in XP. Where did they go in Win7? Thanks.
General Discussion
Why is my Backup data bigger than it's source
Hi, I wondering if anyone can help answer a problem I am experiencing with using Windows 7 own backup tool. I have two 500GB hard drives in my system. Drive 0 is partitioned with 390 GB as the C: drive containing Windows 7 and user data, the remaining space is unallocated ready for me to...
Backup and Restore

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 10:16.
Twitter Facebook Google+