Lotus Notes 8.5 exporting mails that have the body included.

Posted on 2011-04-22
Last Modified: 2013-12-18
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.
Question by:gnomer001
    LVL 46

    Accepted Solution

    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?


    Author Comment

    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.
    LVL 10

    Assisted Solution

    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

    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.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    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!

    How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
    Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
    Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
    This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

    779 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

    14 Experts available now in Live!

    Get 1:1 Help Now