Chapter 12. Going Beyond the Basics


  • Creating Word shipping labels with information about shipments

  • Creating Excel PivotCharts filled with Access data

  • Emailing Access reports of shipping and reordering information

Earlier chapters in this book described how to work with Word, Excel, and Outlook, using VBA code to create Word documents, Excel worksheets, and Outlook items and fill them with data from Access. This chapter describes some more advanced techniques for working with other Office components, such as those you might need in a database with shipping and ordering information.

Creating Fancy Word Shipping Labels

In Chapter 6 you learned how to create basic mailing labels, with name and address information pulled from a table or query, using either the TypeText method or mail merge. A name and address is all you need to print a set of labels for a monthly mailing to a list of club members, or to a list of people who receive a regularly scheduled product shipment. But in the real world, often there are much more complex requirements for printing labels. Before shipping a product, you might also need to check the inventory for a product, the date the product is required, and the availability of shipping supplies, vehicles, and personnel to do the shipping.


The sample database for this chapter is Northwind Plus.accdb.

You might also need to print more information on your shipping labels in addition to the address, such as the Order No., Product No., Product Name, Category, ...

Get Access™ 2007 VBA Bible: For Data-Centric Microsoft® Office Applications now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.