Solved

direct mail

Posted on 1999-01-06
7
236 Views
Last Modified: 2013-12-18
I have a database which works like an appointment with many documents that contain people names, addresses and phones.  I´d like to know how to build something like a direct mail, in order to print labels.
0
Comment
Question by:ptenuta
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
7 Comments
 

Accepted Solution

by:
mhamra earned 20 total points
ID: 1117862
I think there`s nothing you can do to print labels from Lotus Notes client. Will be better for you read Lotus Databases from C/C++, VB, PowerBuilder, etc. program using a Lotus Notes API, or another specific tool. Another way is to access via NotesSQL ODBC with any tool. Tell me what tool do you prefer to use and I'll help you to find the right library.
0
 

Author Comment

by:ptenuta
ID: 1117863
Could you tell me more about accessing via NotesSQL ODBC ? How would it work ?
0
 

Expert Comment

by:mhamra
ID: 1117864
It´s a ODBC driver that you can use from any tool that uses this middleware, like Cristal Reports, VB, PowerBuilder, etc. You can create a datasource and make any kind of SQL Query. If you don`t have any performance requirement, you can use it.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:ptenuta
ID: 1117865
But the data are already in notes documents. I want to read from the fields of Notes documents, and make a direct mail from there. I don´t understand where I would use SQL queries ...??
0
 

Expert Comment

by:mhamra
ID: 1117866
Yes, the data you will query are lotus Documents and their fields. It is not a conversion tool. The ODBC driver executes your Queries retrieving rows from Notes Documents (each row will be a different document). I don't remember well, but I think that your Database forms and Views are seen by this drivers as SQL tables. You don't have to worry about the search mechanism, it is solved by ODBC layer. I've never used them in production environments, but it works. Obviously, if you look for high performance, this is not the right choice, will be better to program in Notes C/C++ API.
Other think that you can do is to export a view to a file and use other tool to perform your Direct mail (like Word mail-merge)
0
 

Author Comment

by:ptenuta
ID: 1117867
I think this option (export a view to a file and use other tool to perform Direct mail) would be nice to me . You said I could use "Word mail-merge". Where can I find it ?

0
 

Expert Comment

by:pab19
ID: 1117868
if you are using a standard sheet of labels say three arross and five down you cando as follows:
create a form
create five layoutregions on the fist layout region create five fields NAME_1 , ADDRESS_1_1, ADDRESS_2_1,ADDRESS_3_1,ADDRESS_4_1
then make put them underneath each other on the left the in the middle do the same but addone to the last number of each field then the same for the right hand side of the layout now repeat this until all the layouts are filled.
now create a postopen script that does as follows
gets the first document in the view then start a counter from 0 (counter = counter+1) now use a  for while loop to populate the fields remembering to say that when counter = 25 print and blank all the fields use a for all statement
this is the perfect label printer yet you willneed to play around with thelayout regions and printer margins a bit
hope you still needthis
if you need any help
mail me
at
pete@britannia-movers.co.uk
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For Desktop Techs: How to retain a user's Notes configuration data when swapping out the end user's computer. (Assuming that you are not upgrading to a completely different version of Notes client) All you need to do is: 1) install Notes o…
I thought it will be a good idea to make a post as it will help in case someone else faces these issues. I trust this gives an idea how each entry in Notes.ini can mean a lot for the Domino Server to be functioning properly. This article discusses t…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
Suggested Courses

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question