address labels

[Lawrence Ryz]

I have created a basic MS Access database for a family
business some time ago and never got round to using it's
most important function - creating address labels from the
customer's address details which would then be used for
mailshots etc.

Can anyone explain how to achieve this function in a basic
way, I think it must be a reports function?

 

[Larry Linson]

There are Label Wizards available either with or for every version of
Microsoft Access. There are minor differences between some versions, and
some must be downloaded from Microsoft's or Avery's website.

The formatting will, of course, depend on the labels you are using, but most
are multicolumn (e.g., 2-up, 3-up, or 4-up), small to modest size... the
actual labels will be the Report detail, and most likely, you won't use a
Report or Group Header or Footer. Sometimes a header or footer, sized the
same as a detail, is used as a separator.

Larry Linson
Microsoft Access MVP