Mail Merge VBA???

[nath]

Hi can anyone help with a web site, help, where i can
learn about the VBA code in order to compile labels from
an access db, from within excel. I am close, but still
need a bit of help.

TIA

Nath

 

[Doug Robbins - Word MVP]

You can print labels directly from Access. Why involve three software
packages?

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

 

[nath]

Only one user using access for db admin, the other users
link in to the database using excel.

 

[Cindy M -WordMVP-]

Hi Nath,

Hi can anyone help with a web site, help, where i can
learn about the VBA code in order to compile labels from
an access db, from within excel. I am close, but still
need a bit of help.

There's a HOW TO Knowledge Base article written for VB that
will give you the basic approach. Note that I don't approve
of the code, itself (macro recorder junk), but the steps
you need to perform are accurate. You should be able to
find the article by searching the terms

"HOW TO" AND "mail merge" AND labels AND VB

or something very similar.

To summarize: you first need to create a label sheet (which
has nothing to do with the MailMerge object! It's at the
Application.labels level). Then you link up to the data
source and insert merge fields into the labels. (The
process is a bit different for Word 2002/2003)

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Sep 30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail