Ask Your Question

How can I create mailing labels from a selective SQL query? [closed]

asked 2013-12-29 23:16:50 +0100

deadghost gravatar image

updated 2014-06-10 22:19:04 +0100

bencomp gravatar image

I can create mailing labels that take SQL table fields and populate a labels template with their values via File -> New -> Templates. The problem is it uses all rows when I want to use a SQL WHERE clause to select only some rows.

Am I supposed to make the query in Base first then pass the data in somehow?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-25 00:22:40.013162

1 Answer

Sort by » oldest newest most voted

answered 2013-12-30 00:22:20 +0100

m.a.riosv gravatar image

I think the way is create a View and use it for mailing list.

edit flag offensive delete link more


That's currently what I'm doing and now I'm trying to restrict it to the first 30 rows. I know the labels template and mail merge are making queries somehow, and I'd be fine(prefer) using an API to program these things in directly instead of messing with GUI.

deadghost gravatar imagedeadghost ( 2013-12-30 00:49:21 +0100 )edit

Ok, got it working with a view and I see the API documentation. All is well.

deadghost gravatar imagedeadghost ( 2013-12-30 00:56:48 +0100 )edit

Question Tools

1 follower


Asked: 2013-12-29 23:16:50 +0100

Seen: 804 times

Last updated: Jun 10 '14