Question Create mailing labels at the click of a button on a form.

[CarysW]

I apologise if this topic has been answered before..

I'm creating a database for a set of end-users who are unskilled in Access. I need to create a custom form for them to be able to create labels from a set of criteria they pick - I already have the queries I would like to use, would I be able to use these for mailing labels or does it need to be a report? And if so can I create code that sets exports the report to Word after it has ran the query(if you see what I mean?)?

Any help or links in the right direction for the VBA are greatfully received.

Thanks
http://www.access-programmers.co.uk/forums/editpost.php?do=editpost&p=876391

 

[DCrake]

I asume that the users will already know what address they have in stock (Avery L6125) for example and they will simply select the label type they are using.

What you need to do is to create these label reports prior and simply tell the system to use this particular label report to print the output.

David

 

[CarysW]

We have custom address labels and I have saved these as a template in access, so when I use the label tool in reports I get the right size, I just need the user to be able to do it by pushing a button on a form as apposed to going through the report route(as they see it).

 

[DCrake]

Can't actually work out what your issue is. Are you experiencing problems?

 

[CarysW]

Can't actually work out what your issue is. Are you experiencing problems?

I should've explained, I don't know how to do it, generally!

I know how to create labels, using the reports tool but I don't know how to create the code to make a report read a query and then export to Word.

 

[DCrake]

Why do you want to bring word into the equasion? You can print the labels from Access.

David

 

[CarysW]

Why do you want to bring word into the equasion? You can print the labels from Access.

David

Ah ha, there's the vital piece of information I have been overlooking! I've been too long working with Excel!

OK, so my End User wants to see the labels before they are printed but not necessarily edit them(out of interest - could they edit the labels or would it have to be in Word to do this?) so I will use the 'OpenReport' command in VBA?

 

[CarysW]

Why do you want to bring word into the equasion? You can print the labels from Access.

David

I think I've worked out why, Access will not recognise my custom labels, they are 2 across by 4 down but when I put the emasurements in it gives me 2 across by 3 down. I have a template in Word that I normally use and it works fine.

Is there any way I can tell Access to put 4 down.

Plus, when I create the report it is for some reason putting filters in that aren't on my query but are in my master table...any ideas why it's doing this?

 

[DCrake]

You may need to reduce the depth of the label to bring the 4th label onto the same page. It's a bit of trial and error at first to ensure that the dimensions are correct.

David