Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel Mailmerge Help

Status
Not open for further replies.

jak893

Technical User
May 26, 2009
1
GB
Hi
I'm trying to create a macro that will create a series of invoices and print them all from within Excel. I'm using the code found at but when ever I execute the macro it opens Visual Basic and says that there's an error with the range name. As far as I can tell I've set everything up exactly and I'm now at a complete loss of what to do.
Would any of you be able to give a step-by-step on how to accomplish this or explain the above tutorial in a bit more detail.
Cheers
 
Hi jak,

Since you're after a set of invoices, presumably there's a prospect of having more than one record per recipient.

You can use Word's Catalogue/Directory Mailmerge facility for this (the terminolgy depends on the Word version). To see how, check out my Word 97-2007 Catalogue/Directory Mailmerge Tutorial at:
or
Do read the tutorial before trying to use the mailmerge document included with it.

AFAICS, the process in the link isn't designed to work with a multi-line invoice, so it'd need some work before being ready for that task.

Cheers

[MS MVP - Word]
 

Hi,

Since you're running this in Excel, which is what I would also recommend, there are several ways to attack this.

Method 1: AutoFilter Method.

This assumes that the Invoice data is in tabluar format and in presentation format. You would loop thru a list of the invoices that you want to print, filter on the invoice id & print.

Method 2: MS Query Method.

You would loop thru the invoice you want to print, query each invoice in an InvoicePrint sheet and print. faq68-5829

Pick your poison.

Skip,

[glasses]Just traded in my old subtlety...
for a NUANCE![tongue]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top