• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 249
  • Last Modified:

Excel As A Mail Merge?

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).

TIA
0
Clif
Asked:
Clif
1 Solution
 
hitsdoshi1Commented:
Not without VBA codes. There is no in-built functionality in excel like mail merge (At least not in 2003 & 2007).
0
 
ClifAuthor Commented:
Oh well.  

Thanks anyway.
0
 
ScriptAddictCommented:
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

-SA
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now