AnuKass
29th August 2018, 09:15
hii i'm new for LN..
Is possible to read mail from outlook using LN program??
if yes pls explain in detail and as soon as possible ??:(

VishalMistry
29th August 2018, 11:19
Hi,

If you mean to read mail from Local Outlook profile, then yes. You can automate Outlook from within excel. That is fairly easy.

If you can clearly define your requirement, I can guide you with required steps, along with sample Excel macro on how to read mail.

Regards,
Vishal

AnuKass
29th August 2018, 14:51
i want to get unread message from outlook and save it to table separately..like from address ,to address,subject,message content
is it possible???

VishalMistry
30th August 2018, 10:36
i want to get unread message from outlook and save it to table separately..like from address ,to address,subject,message content
is it possible???

I don't know if this can be achieved through e-message connector. But yes, it is very much possible with the help of VBA Macro written in Excel. Below is a link to sample example of Outlook automation from within Excel macro. But in this case, it will read unread message from local outlook profile and not any email application that operates as web app.

http://timothychenallen.blogspot.com/2008/08/outlook-vba-script-to-display-all.html

All you need is to create an excel file perhaps with a user form with a command button. When you click on that button, it establishes connection to your ERP database. Once this is done, the macro in given link loops through unread messages, and you need to write a code to insert the record in Baan table.

Hope this helps.
Vishal

AnuKass
30th August 2018, 10:58
Hi..VishalMistry
thanks for your reply ...
i will try it in VBA script ..

AnuKass
31st August 2018, 13:55
hii
i tried VBA script ..But i have some doubt ??
fetchUids=1
Set messageSet = imap.Search("ALL", fetchUids)
Set bundle = imap.FetchBundle(messageSet)
I get object required error from above line ???
Is any another way to change email to bundle object??