Kind of mailmerge but with mailing labels

[GSGarden]

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

 

[Charles Kenyon]

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.

--

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.

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

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.

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

 

[GSGarden]

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

 

[GSGarden]

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.

 

[Peter Jamieson]

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.