First trial to create note from Outlook

rami.sedhom · 2019-12-30T12:33:39.841Z

Tekki:

When I go to my older posts I have an edit this post button

May be because you are an old member with lot of badges

235462849350:

But running the code I only get 5 notebooks as a clipping destination. But I have created a lot more:)
Where can this be changed?

This is true, I create 6 notebooks and api GET folders returned only 5!
There is noting in the code limiting the number of folders, and there is nothing in the api documentation about limitation in response. So I'm not sure what's the solution.

@laurent, @Tekki, @tessus any advice about this limitation?

235462849350 · 2019-12-30T13:58:05.625Z

@rami.sedhom:
Another question:
Right now it seems, that only “to” , the date and the mail text are sent to Outlook.
Would it be possible to sent the whole header, like this:

From: xy xy xy.xy@domain.com
Sent: Samstag, 9. November 2019 22:29
An: aa.bb@domain.com
Subject: bla bla

This is the mail text

Tekki · 2019-12-30T14:12:47.209Z

235462849350:

Right now it seems, that only "to" , the date and the mail text are sent to Outlook.

This is just an example I've made. In one of the above posts I've already added a link to the docs for the MailItem props. You can add to your script whatever you like to see.

laurent · 2019-12-30T14:14:27.957Z

rami.sedhom:

This is true, I create 6 notebooks and api GET folders returned only 5!

A screenshot and corresponding JSON might help. Note that /folders return a tree of folders so sub-folders won't be at the root.

rami.sedhom · 2020-01-03T15:29:13.128Z

235462849350:

But running the code I only get 5 notebooks as a clipping destination. But I have created a lot more:)

I tried today and works fine
Would you try and confirm?

235462849350 · 2020-01-05T14:16:58.604Z

Don`t know why, I did not change anything, but no I can select all my notebooks. Strange, but it works:)

rain · 2021-03-03T03:18:56.404Z

Thank you very much for this great plugin. It works like a magic, but can be nicer if the two places can be improved (in my opinion):

The attached file of the email will not be imported to Joplin (no matter pdf or photos), don't know if I missed something here?
It will pop up folder selection for each file when I have many files to be imported to Joplin. It can be nicer if only one selection is asked for one import action (no matter how many files are going to be imported to Joplin) .

skim1124 · 2021-03-03T08:44:15.924Z

How do I find the sToken for Joplin? I can't seem to find any answers here or through Google. Can someone help?

JackGruber · 2021-03-03T09:13:37.433Z

Tools > Options > Web Clipper there you can find the Token.

skim1124 · 2021-03-03T09:25:25.260Z

Thanks! But even using that token, I can't seem to get this to work. Not surprising since VBA/code/json are all completely alien to me. I pasted the "SendtoJoplin" code into ThisOutlookSession in VBA. And I imported the json.bas so that it shows up under Modules. And I added a shortcut to the macro in the Quick Access Toolbar in Outlook (2019). But when I click on the shortcut, nothing happens. Did I miss something or make a common error that I'm not aware of?

rain · 2021-03-03T23:02:24.189Z

Have you put the parent_id of your notebook into the field it should be? You can find the parent_id in you cloud drive fold, for instance i use onedrive. I find one parent_id in one of my *.md files that are stored in my Onedrive fold.

I make it worked yesterday, but it suddenly doesn't work, don't know why. Strange to me.

skim1124 · 2021-03-04T00:59:15.964Z

~~I use Dropbox to sync, but can you tell me how to find the parent_id?~~
Never mind. I found it. But I must not be placing it in the right place. Can someone show me exactly where I should put the parent_id?

Cmely · 2021-03-28T17:32:53.390Z

Have you found how to make it works ?
I'm curently at the same stage than you : pasted code, imported json.bas, added token, added button in QAT, and I get no result when clicking on it.

When I try to debug the macro, it stops immediately (first line) with the message : "Error 424 : object not found".

What did I miss ?

skim1124 · 2021-03-29T17:26:26.744Z

Sorry, but I can't help you. I haven't figured out how to get it to work.

Namtrah · 2021-10-19T09:21:13.789Z

Have used this plugin for over a year now, but since Joplin upgraded to 2.3 or so (where the sToken changed mysteriously) now it does not work.

Yes, I updated the sToken. But it doesn't really find any folders. I only get a choice of 0 and 1 and whatever that means it doesn't save to any Joplin folder?

Did the API change? @rami.sedhom are you still using it?

Namtrah · 2021-10-19T14:47:46.370Z

OK, I can find the notes. They do seem to be imported into Joplin, but I cannot find under which NoteBook they lie (I can search and find them, but they do not show up under any single notebook I created. They seem hidden until I search for them. Adding a screen shot from the actaul pop up asking to choose a Notebook ("from 0 to 1")

joshb · 2022-10-18T11:46:59.617Z

@rami.sedhom i use this code on the regular every day, and my workflow wouldn't work, or flow, without. I wanted to take a moment and give a massive thank you for putting it together.

i dabble in vba, so can adjust the code marginally by myself, but haven't had any luck in being able to change the stored note as a to-do, rather than a straight note. Has anyone had any success/any hacks to be able to do this? i send all my emails straight to an Inbox folder in joplin, and the first thing I do to each note is make them all to-dos.

Marph · 2022-10-18T15:33:38.965Z

I have no idea about VBA or Outlook, but maybe a hint about the API helps. There is a query parameter called is_todo (API reference). It needs to be set when creating the note.

You could try to add is_todo: 1 just like adding title, parent_id and body_html (not sure how the quotation marks should be).

KeithC · 2022-11-11T14:13:15.332Z

Using this successfully. I have removed the choice of folders as I always want new notes in my Inbox folder.

Has anyone looked into extending this to handle attachments? My VBA skills fall well below what I would trust to do this. Quite a lot of the emails I want to save have attachments and I would really like them to be sent across as well.

joshb · 2023-02-13T15:24:13.992Z

Marph:

You could try to add is_todo: 1

Yep, this did it. H E R O
A puzzling number of quotes and double quotes, but thanks so much for your insight!

For those wondering, here's my updated Send command:

With CreateObject("MSXML2.XMLHTTP")
            .Open "POST", sURLNotes, False
            .Send "{ ""is_todo"": 1, ""title"": """ & objItem.ConversationTopic & attachmentName & """" _
            & ", ""parent_id"": """ & sFolderID & """" _
            & ", ""body_html"": """ & sEscapedBody & """" _
            & " }"