Solved

direct mail

Posted on 1999-01-06
7
233 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
  • 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
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

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

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

For users on the Lotus Notes 8 Standard client, this article provides information on checking the Java Heap size and adjusting it to half of your system RAM in attempt to get the Lotus Notes 8.x Standard client to run faster.  I've had to exercise t…
  In today’s Arena we can’t imagine our lives without Internet as we are highly used to of it. If we consider our life style just for only 2 min we found that face to face communication is swapped by e-communication.  Every Where from Works place to…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

746 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now