• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1790
  • Last Modified:

Lotus Notes 8.5 exporting mails that have the body included.

Dear Experts,

I was wondering if there is a way to export a mail to excell with the body included. For example, if we do this now we select mails from the inbox, go to 'export', select 'Tabular Text'
a file with no extention is created. Now as soon as we rename this file to .csv and open it in excell it looks perfect. Except, it has no body included. So we have 'Who', 'Time', 'Subject' etc but not what's in the mail. My question now is, is there a way to also include the body (content of the mail) into this exported file or not. And if not, is there a way to actually get this done?

Thanks in advance.

FYI:  Lotus Notes 8.5 / Excell from office 2002

Best regards.
0
gnomer001
Asked:
gnomer001
2 Solutions
 
Sjef BosmanGroupware ConsultantCommented:
You can probably pull this off in VBA or LotusScript, using the COM interface, but only for small mails. The body can be quite large, and I don't know what capacity an Excel-cell has. Plus, what do you intend to do with the attachments?

FWIW:
- http://www.a12d404.net/2011/04/generic-microsoft-excel-importer-for.html
- http://www.botstation.com/code/view2exceladv.php
0
 
gnomer001Author Commented:
It's not for the attachments, it's for the content of the mail. Thing is, we have 100+ mails that are mostly simular except the content is different each time. What we want is actually a good overview of these mails and their content in a sheet (Pref. excell but in another format will do as well)

So again, it's not for the attachments but for the body (text inside the mail).
If other way's are even better would love to hear about them.

Thanks in advance.
0
 
doninjaCommented:
If you are not worried about the rich text content of these fields then you could just get the text only value of the field body.

You can search the forum for lotusscript export for some code.
You cannot use a simple export from view if you wish the body as this field will not display in a view column due to it's format and attributes.
The following is a good view to excel export routine
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/Lotus_SmartSuite/Lotus_Notes/Q_22638864.html?sfQueryTermInfo=1+10+30+export+lotusscript

Just need to add a few lines to put the body text content into a cell.

xlsheet.Cells(rows,cols).Value = datadoc.GetItemValue("body")

This will return an array of strings but should all be put into the same cell in excel.


0

Featured Post

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!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now