email merging using Excel as a data source


  1. monday69
    Posts : 27
    Windows 7 Home Premium 64bit
       New #1

    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 Computer
    Quote Quote

  3. Ranger4
    Posts : 9,746
    Windows 7 Home Premium 64 bit sp1
       New #2

    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 Computer
    Quote Quote

 

  Related Discussions
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,...
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...
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?
DSN's were here (HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\) in XP. Where did they go in Win7? Thanks.
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...
Our Sites
Site Links
About 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 08:40.
Find Us