import email with attachment

trancu

hello everybody,

we use Nav4.0 and Outlook 2003.

Does anybody know how to import an object "email with attachment" from Outlook into Navision.
We don't want to use NAS! :evil: (had too many troubles with NAS)

We can import this email into Navision by "Interaction Templates".
We get this email into the "Interaction Log Entries" with the "Attachment = YES".
But the problem is that we can not open this Attachment!!

When we want to open it, a message pops up:

C/SIDE hyperlinking failed.
You tried to hyperlink to this target:
C:\DOKUM~1\..........\Temp\Doc.msg
Do you want to place that hyperlink target on the clipboard?

Do anybody has a solution?
regards

kriki

Your post is not completely clear. Do you want to import a Navision-fob directly into Navision from an email?

trancu

No, we don't want to import financial objects, instead we want to use the Interaction Log Entries to store CRM-Data (wordfiles, plain textfiles and emails with attachment).

We aint got no trouble with word, text or other files. We can also import Outlook mails with attachment as a .msg file.

But then when we want to open this file via the Interaction Log Entries we get an error message like above (mail is stored in database correctly, when opened also correctly extracted to temp directory but unable to open it automatically.

regards!

Marije_Brummel

Do you mean something like this?

http://www.mibuso.com/forum/viewtopic.p ... =hyperlink

kriki

Not all files can be opened with HYPERLINK.
Check these:
http://www.mibuso.com/forum/viewtopic.php?t=8658
http://www.mibuso.com/forum/viewtopic.php?t=8962

Marije_Brummel

kriki

Mark Brummel wrote:

But I put an extra link

trancu

No we don't use links in the database! When importing files with interaction logs, the whole file is imported into a blob-database-field, so the whole binary is stored in the database, not just the path to a server directory.
We can import every kind of file, but as it seems Navision is not able to open every type of file.
We want to open the file via the interaction log entry (Button Show). It then extracts the binary to a temp-directory on the local harddisk and opens it. It works with all kinds of files like (.doc, .xls, .pdf, .bmp), but it does not with .msg files (Outlook-messages).

May anybody can help us.

Best wishes

kriki

trancu wrote:

No we don't use links in the database! When importing files with interaction logs, the whole file is imported into a blob-database-field, so the whole binary is stored in the database, not just the path to a server directory.
We can import every kind of file, but as it seems Navision is not able to open every type of file.
We want to open the file via the interaction log entry (Button Show). It then extracts the binary to a temp-directory on the local harddisk and opens it. It works with all kinds of files like (.doc, .xls, .pdf, .bmp), but it does not with .msg files (Outlook-messages).

May anybody can help us.

Best wishes

You have to add some code. It uses HYPERLINK to open those files. If it is a msg-file, you have to export the BLOB and use automation (see the links we gave you) to open it. Or if necessary use SHELL with the program and parameters to open the msg.

trancu

Thanks,

we will try it, but sometimes later.

have a good day!!