Access.2007.VBA.Bibl..

E

arlier chapters in this book described how to work with Word, Excel,

and Outlook, using VBA code to create Word documents, Excel work-

sheets, 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 ship-

ping 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 prod-

uct, the date the product is required, and the availability of shipping sup-

plies, 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, the case number in a sequence of cases, or other such data. To

print labels with extra information, or to make decisions on whether a set of

labels should be printed, you need more elaborate VBA code.

NOTENOTE

IN THIS CHAPTER

Creating Word shipping labels

with information about

shipments

Creating Excel PivotCharts filled

with Access data

Emailing Access reports of

shipping and reordering

information

Going Beyond

the Basics