Kind of mailmerge but with mailing labels

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

GSGarden - 25 Feb 2004 20:54 GMT

I would be grateful if anyone could help or point me in the right direction
with my little problem.

I want to be able to print a list of addresses from my database onto mailing
labels using Word, from my app. I want to automate the process as much as
possible even hiding Word during the entire process if possible. I would
also like the user to be able to select the label size as in Word.

Thanks inadvance,

GSG

Reply to this Message

Charles Kenyon - 25 Feb 2004 21:25 GMT

I would recommend starting by exploring label mailmerge in Word. Then look
at the vba model involved. Then write your code. If you have specific coding
problems, ask on the vbabeginners newsgroup with the code that is giving you
problems in your message.

Signature

Charles Kenyon

See the MVP FAQ: <URL: http://www.mvps.org/word/> which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

> I would be grateful if anyone could help or point me in the right direction
> with my little problem.
[quoted text clipped - 7 lines]
>
> GSG

Reply to this Message

GSGarden - 26 Feb 2004 20:26 GMT

I had already searched MSDN and looked at Word's Object Model for anything
on label mailmerge before I posted to the newsgroup.

All the help and samples that I found referred to a generic mailmerge, where
the dimensions of the document are plucked from thin air and then passed to
the relevant object. I had hoped somebody in this newsgroup might know off
the top of their head. As you've suggested, this probably is the wrong
newsgroup.

Thank you anyway.

Signature

GSG

Reply to this Message

Peter Jamieson - 27 Feb 2004 12:40 GMT

I don't have any off-the-shelf code for this either, but probably worth
looking at Dialogs(wdDialogToolsCreateLabels) if the examples just cover
Label doc. creation rather than label layout and setup. You don't have much
control over it of course.

--
Peter Jamieson - Word MVP
Word MVP web site http://word.mvps.org/

> I had already searched MSDN and looked at Word's Object Model for anything
> on label mailmerge before I posted to the newsgroup.
[quoted text clipped - 9 lines]
> --
> GSG

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 25 Feb 2004 23:38 GMT

You did not tell us what database you are using, but if it is Access, it has
a wizard to create a label type report.

Signature

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

>I would be grateful if anyone could help or point me in the right direction
> with my little problem.
[quoted text clipped - 8 lines]
>
> GSG

Reply to this Message

GSGarden - 26 Feb 2004 20:19 GMT

Sorry, I didn't think it was relevant. I am using SQL Server and I am not
using Access as the front end either. I will be using Delphi to access
Word's Object Model.

Even if someone knows how to do it in VB or C++, would be helpful because I
can easily translate it to Delphi.

GSG

Reply to this Message