Excel As A Mail Merge?

Posted on 2011-10-26
Last Modified: 2013-11-05
The engineering departments use a Word document where fields can be filled in from our SQL Server database.

Is it possible to do something similar in Excel?  One of the departments has their design template in Excel instead of Word (it's a customer requirement).  I know it can be done through VBA as a macro, but I was wondering if there's an easier way of setting it up (as I said, similar to Word's mail merge).

Question by:Clif
    LVL 9

    Accepted Solution

    Not without VBA codes. There is no in-built functionality in excel like mail merge (At least not in 2003 & 2007).
    LVL 11

    Author Closing Comment

    Oh well.  

    Thanks anyway.
    LVL 11

    Expert Comment

    This likely isn't anything different then you already know

    Regarding SQL
    There is MS Query that is a very helpful way to get database information into an Excel worksheet.  I'm not aware of any reason this wouldn't work for you in this situation and is fairly easy to use.

    SQL Database Pull

    Regarding Mail Merge using Addresses in Excel:
    Mail Merge using Excel and MS Word


    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    What is a Form List Box? (skip if you know this) The forms List Box is the alternative to the ActiveX list box. If you are using excel 2007, you first make sure you have a developer tab (click the Orb)->"Excel Options"->Popular->"Show Developer tab…
    Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
    The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now