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.