Sandler, Adam
2010-02-16T12:39:00Z
I have my email getting stored in SQL server via Genius Connect - and I have it saved exactly in the formats given in SQL examples.

Then these records are linked to the existing data within my database.

How however do I show to my users what the email and its content was - and have it usable (ie they can reply, forward etc etc the email)

Do I push the whold mail record back to outlook (the original outlook record may be deleted) and then open it somehow. Or do I build it again , with code form my FE. Particularly how do I add back in attachments, which seem to have no link from the ref in the HTML code to where geniusconnect has stored them in my specified folder.

Thanks

Sponsor
GeniusConnect documentation search (User Manual Downloads...)
Administrator
2010-02-16T13:35:00Z
to load an record (email) from db:
-you can use toolbar - Load All, Load Item (only selected item)
-scheduled sync (Load All)
-or implement database change detection (Help topic: Database change detection)

There is no way to open an item in Outlook using GeniusConnect.

To build a HTML body with an attachment (see also help topic: Item attachments):
-store an email with HTML and attachment to DB and investigate the data
There are many ways how outlook handles attachments:
-Attachment method
Constant representing the way the contents of an attachment can be accessed.
1=Attachment binary contains the attachment data by value
2=full path and filename contains a fully qualified path identifying the attachment to recipients with access to a common file server
3=full path and filename contains a fully qualified path identifying the attachment
4=Same as 3 but the messaging system never resolves the reference(link only)
5=Attachment binary is an embedded message
6=Attachment binary is an embedded OLE object

If attachment is embedded inside your HTML body, the method is often 1, 5 or 6 but it depends on attachment type.
See also Attachment rendering position:
Offset, in characters, to use in rendering an attachment within the main message text.
All values other than 1 indicate the position within *HTMLBody at which the attachment is to be rendered.


If it is an regular attachment (not in the body), see the other methods.

Similar Topics