Ask Your Question
1

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

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

deadghost gravatar image

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

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
0

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

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

Comments

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 +0200 )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 +0200 )edit

Question Tools

1 follower

Stats

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

Seen: 665 times

Last updated: Jun 10 '14