Automatic tracer pulling multi records

Posted on 2006-04-10
Medium Priority
Last Modified: 2013-12-18
OK I have another challange, Last week you guys assisted me in importing data from a spreadsheet into records in a notes db. The next challenge is to create a tracer email sent out to an office 30 days in advance of machines being due to be replaced.

I need to have the information from multiple record condensed into one email for all records for the same office_id field that fall on that refresh date. The email should have the data from the form in a table like format. It will be a grid like below

userid    asset     serial
userid    asset     serial

I have been told that I can do this using a Rich Text Field and format the tabs into the code so it appears as a table.

Because I know this is probably a lot of code, I will post this same question again once the answer is received and give the correct response 1000 points, or split if joint effort.

Question by:jforget1
  • 3
  • 2
LVL 46

Accepted Solution

Sjef Bosman earned 2000 total points
ID: 16424901
1. EE is not a rent-a-coder site
2. offering more than 500 points won't be allowed

Here's an example how to create and send a mail:
    http:Q_21026807.html "Sending Notification"

Author Comment

ID: 16425904
I did not intend to offend anyone, I just wanted people to know that I appreciate the effort I always get from this site.

I know how to get the tracer together, I just do not know how to make it where it wraps up the records into a table like format.
LVL 46

Expert Comment

by:Sjef Bosman
ID: 16426165
I know, I just thought to warn you about "nasty consequences" ;)

So you want a table. You need at least R6 to do that, with the NotesRichTextTable class. The Designer Help contains an excellent description of that class and an equally excellent example.

Other interesting info:

Author Comment

ID: 16426389
I will give this a try and see if I can get this together. THe whole script thing is very confusing when you are not doing it full time.
LVL 46

Expert Comment

by:Sjef Bosman
ID: 16430788
Great! When you made a giant step for mankind, dump your code here and tell us what doesn't work. We'll try to pull you through.

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

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…
For beginners of Lotus Notes user this is important to know about the types of files and their location supported by IBM Notes. Mostly users are unaware about how many file types are created and what their usages are. This Article is fully dedicated…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses
Course of the Month16 days, 19 hours left to enroll

862 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