Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Importing Lotus Notes Mails to Access
- Thread starter thetarzan
- Start date
Sure, there are several ways.
One is to write a little agent that will go over all selected docs and export the Body field to a text file.
Another is to use File/Export and write your memos to a Structured Text file.
In all of these, you will lose any attachments that came in the mail.
But I cannot see the interest in writing code or making menu operations just to avoid opening mail. What is the issue with opening mail ? Is it fear of viruses ?
One is to write a little agent that will go over all selected docs and export the Body field to a text file.
Another is to use File/Export and write your memos to a Structured Text file.
In all of these, you will lose any attachments that came in the mail.
But I cannot see the interest in writing code or making menu operations just to avoid opening mail. What is the issue with opening mail ? Is it fear of viruses ?
tonymullen
MIS
I've not tried it, but a quick search in the lotus notes sandbox brought this back:
- Thread starter
- #4
The point is that I have to send a survey (excel file) without any server support. The excel file will write a line of code (the answers) in the mail's body. (I wrote this step already).
Because of the amount of email I'll receive (5000), I want to open all the emails and get the first line of it, to be written in a text file that I could import in an access file.
Got any ideas... I barely know how to execute this task!
Because of the amount of email I'll receive (5000), I want to open all the emails and get the first line of it, to be written in a text file that I could import in an access file.
Got any ideas... I barely know how to execute this task!
OK, if I understand correctly, you have a process which sends you a line of text in the body of a mail. You have Notes mail, so you must have a server somewhere.
Off the top of my head, you can do either of two things :
1) receive all mails in a mail-in database. Make an agent that extracts the first line and writes it into a different Notes document - lets call it the Results document. Create a view that lists all of these Results. When all responses have been received, export the view to a text file and open in Access.
2) Receive all responses in a mailbox. Replicate locally. Make an agent that goes over all docs and writes the body field into a text file. Open file in Access.
Actually, if you have the correct ODBC filter for Access, you can even open the mail-in from 1) directly, without writing to a file.
What do you think ? Tell me which solution you would like to employ, I'll send you some code when I know what you want to do.
Off the top of my head, you can do either of two things :
1) receive all mails in a mail-in database. Make an agent that extracts the first line and writes it into a different Notes document - lets call it the Results document. Create a view that lists all of these Results. When all responses have been received, export the view to a text file and open in Access.
2) Receive all responses in a mailbox. Replicate locally. Make an agent that goes over all docs and writes the body field into a text file. Open file in Access.
Actually, if you have the correct ODBC filter for Access, you can even open the mail-in from 1) directly, without writing to a file.
What do you think ? Tell me which solution you would like to employ, I'll send you some code when I know what you want to do.
- Status