Dear Sir,
I'm trying to load the email attachments through my database but I can't. Are there any tips for loading my email attachments without saving them in an external location?

Also I would like to ask if there's any way to click on an email from my database and open-load the outlook application with the details of that specific email.

Thank you

"I'm trying to load the email attachments through my database but I can't. Are there any tips for loading my email attachments without saving them in an external location?"
GeniusConnect can load attachmets directly from your db if they stored in blob column (Binary Large Object), it is not prescribed to store them in an external location

"Also I would like to ask if there's any way to click on an email from my database and open-load the outlook application with the details of that specific email."
No, it is not possible to click on a record in your DB and open it in Outlook. GeniusConnect synchronizes Outlook data to/from your DB.

you will have to describe your database so we can advice you how to load the data to Outlook

Hello,

Thank you for your answer,
Genius Connect process gives me the message "Attachment nr is not linked to a database field. Can't process attachments!".
I'm trying to understand what is nr (maybe number), so which field is that and with which field has to connect?

Attachment number
MUST BE LINKED TO A TABLE COLUMN! Contains a number that uniquely identifies the attachment within its parent message.

Please see Help: (F1 button or Help button) there is detail description of every Outlook attachment column 

I created one table column AttachmentNumbers in my database and I connected that with the Attachment number. But now it deletes my attachments when I try to open the emails. Also still not showing the attachments in my database.

What are the values in AttachmentNumbers column? is it any valid/real value ?
AttachmentNumber: Contains a number that uniquely identifies the attachment within its parent message.

Example:
mail has 2 attachments

Mail Record example:

MailID: 12345
MailSubject: subject
MailBody: somebody

Mail attachment records example:

Record 1:

parentMailID: 12345
AttachmentNr:0
Blob:xxxxx
etc..


Record 2:
parentMailID: 12345
AttachmentNr:1
Blob:yyyyyy
etc..

Hello,

When I save the settings for the attachments, in the database are inserted new lines (under each record) where are being putted the attachments.
For Example I have:


Name, Surname, Email Subject, Email Descr, Sender, Received On,Attachment,AttachmentNumber
Record 1: ...., ..., ...., ......, ....., ........, NULL, NULL,
New line NULL,NULL, NULL, NULL, NULL, NULL, NULL, 0

Record 2: ...., ..., ...., ......, ....., ........, NULL, NULL,
New line NULL,NULL, NULL, NULL, NULL, NULL, NULL, 0
New line NULL,NULL, NULL, NULL, NULL, NULL, NULL, 1

How can I fix this?
Thank you

Can one Outlook folder connect with two tables through SQL database?

Hello,

One email can have multiple attachments, you should store the attachments in a child table

Example:
Table: Mail
Child Table: MailAttachment

Please see Help topic: Item attachments

Can one Outlook folder connect with two tables through SQL database?
https://support.geniusconnect.com/topics/14-