Consulting

Results 1 to 5 of 5

Thread: Convert Lotus Stationery to Outlook

  1. #1

    Convert Lotus Stationery to Outlook

    Hi Friends,
    I am working in a process of Migration of Lotus notes to Outlook 2003.In this i am stuck up with the stationery convertion to outlook.
    I am able to copy all the subject,CC,TO,BCC and body from the stationery to Outlook new mail body.But my problem is, if i have any table template in a stionery that is not coming to outlook.
    pleale help me out to sort out this issue.


    I am using following VBA code to stationery convertion.
    -----------------------------------------------------
    Do Until entry Is Nothing
            With entry.Document
                Set Word = CreateObject("word.application")
                Set doc = Word.DOCUMENTS.Add
                Set selection = Word.selection
                selection.typetext .GetItemValue("body")(0)
                selection.typeparagraph
                doc.SaveAs ("C:\TestDoc.Doc")
            End With
            counter = counter + 1
            Set entry = entries.GetNextEntry(entry)
            Word.Quit
            Set fs = Nothing
            Set Word = Nothing
        Loop
    I'm a first time poster and been struggling with this for a while and hoping to get some advice. As the title says I want to send an automatic email to my contacts who's birthday falls on their birthday which is triggered by a a daily task called Birthday Text as the subject. I have this working with code I found on the net, i.e. the task is triggered and it sends the email. What I want to do though is dismiss the reminder automatically. I have 2 separate VBA codes snippets that both work in isolation i.e. one that sends email via a task and the other that dismisses the notification, however when I try to merge these 2 snippets together I get errors that I cannot debug because I don't have the expertise. Could someone please look at the 2 codes below and assist or point me in the direction on having these working together?

    Thanks in advance.
    Shiva.


    Last edited by macropod; 12-19-2018 at 06:07 PM.

  2. #2
    I read your question and I would recommend this article. Click here: https://www.softaken.com/kb/lotus-no...without-errors

  3. #3
    This is a little bit risky. Yo can directly convert Lotus Notes to Outlook easily in a few minutes with a third party tool like from eSoftTools. Explore more here: https://www.esofttools.com/nsf-to-pst-converter.html

  4. #4
    VBAX Wizard
    Joined
    Apr 2007
    Posts
    6,662
    Location
    Quote Originally Posted by mike-lewis View Post
    I read your question and I would recommend this article. Click here: https://www.softaken.com/kb/lotus-no...without-errors
    Welcome to the forum

    Please take a minute to look at the FAQs at the link in my sig

    Thanks for replying, however the OP's question is about 8 years old, so I doubt they have any interest
    Paul

    ------------------------------------------------------------------------------------------------------------------------
    1. Use [CODE] ....[/CODE ] Tags for readability
    [CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
    2. Upload an example
    Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s)
    (multiple files can be selected while holding Ctrl key) / Upload Files / Done
    3. Mark the thread as [Solved] when you have an answer
    Thread Tools (on the top right corner, above the first message)
    4. Read the Forum FAQ, especially the part about cross-posting in other forums
    http://www.vbaexpress.com/forum/faq...._new_faq_item3

  5. #5
    VBAX Wizard
    Joined
    Apr 2007
    Posts
    6,662
    Location
    Quote Originally Posted by kellyjohnson View Post
    This is a little bit risky. Yo can directly convert Lotus Notes to Outlook easily in a few minutes with a third party tool like from eSoftTools. Explore more here: https://www.esofttools.com/nsf-to-pst-converter.html

    Welcome to the forum

    Please take a minute to look at the FAQs at the link in my sig

    Thanks for replying, however the OP's question is about 8 years old, so I doubt they have any interest
    Paul

    ------------------------------------------------------------------------------------------------------------------------
    1. Use [CODE] ....[/CODE ] Tags for readability
    [CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
    2. Upload an example
    Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s)
    (multiple files can be selected while holding Ctrl key) / Upload Files / Done
    3. Mark the thread as [Solved] when you have an answer
    Thread Tools (on the top right corner, above the first message)
    4. Read the Forum FAQ, especially the part about cross-posting in other forums
    http://www.vbaexpress.com/forum/faq...._new_faq_item3

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •