understanding automating MailingLabels

[Sam Carleton]

I need some help understanding the concept of MailingLabel. Here
is my problem: I have an Access database that contains a list of
addresses. I have already written a VBA script to generate a
directory for the list of addresses. Now I need to figure out how
the MailingLabel feature works. Where might I go to learn the
basics of how it works?

 

[Doug Robbins]

Access has a report wizard for creating labels. Why don't you use that?

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

 

[Sam Carleton]

Access has a report wizard for creating labels. Why don't you use that?

That would be great, except... My users are not real computer
literate, I would like to simply have a macro they could run once
a month when they need to make labels.

Also my data is not standard. The data is coming from an Access
Database. There are two "address" fields, if the first is NULL,
then the second should be used. The wizard does not allow for
these types of complexity from what I can tell. I am trying to
figure out how to create an Access queue that consolidates the two
fields correctly, but am having problems with that.

any thoughts?

 

[Doug Robbins]

Use a query in Access to deal with the empty address fields. Once YOU have
the report set up, all the users have to do is run it.
--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP