To clarify the Outlook limitation: Outlook / Office 365 does not provide a separate "Street 2" property. Each address type (Business, Home, Other) only exposes one Street field. Because Outlook has no dedicated place to store Street 2, GeniusConnect cannot map it directly.
Since you already have Street 1 and Street 2 in your database, the solution depends on your sync direction:
• If you sync only from DB → Outlook: This is straightforward. You simply combine Street1 and Street2 before sending the data to Outlook. You can do this either:
by concatenating the fields during write-back (e.g., Street1 + ' ' + Street2), or
by creating a database view that prepares the combined Street value. GeniusConnect can then map this view directly to the Outlook Street field. Please see
Views • If you sync both ways (DB ↔ Outlook): Writing back from Outlook into two separate DB fields becomes more complex, because Outlook only returns one combined Street field. In this case, you must decide how to split the single Outlook Street value back into Street1 and Street2 — or store it only in one DB field.
The exact SQL syntax depends on the database you are using (SQL Server, MySQL, PostgreSQL, etc.). If you let us know which one, we can provide a ready-to-use example.