VBA Code to print mailing labels (Access 97)

Topic

New Reply

Hi,
I need to write VBA code, so that with a push of one button user should be able to generate/print mailing labels.
I also need VBA code to send automatic emails….
Help needed urgently
Thanks,
isha

Reply | Quote

Replies

Mailing labels are no more than a simple report. When in report, from main menubar, select File | Page Setup, then the Columns tab. To automatically start printing, put a command button on a form. When the wizard pops up, tell it you want to print a report.

Reply | Quote

If you want to start the Label Wizard from a command button, use

Run “wzmain80.mlbl_Entry”, “sourcename”

where sourcename is the name of the table or query that will serve as record source for the label report.

If you want to print a report from a command button, see Mark’s reply.

If you want to send e-mails from Access using Outlook, look at the SendObject method of the DoCmd object in the help index, or take a look at this post.

BTW, you write “help needed urgently”. Please keep in mind that all answers on this Lounge are given by volunteers donating some of their free time to help people.

Reply | Quote