SAP Business One Consultants | IT Support | 0843 886 1449

All posts tagged SAP Business One Email

Business Partner Email Report SQL HANA

Warning: fsockopen(): unable to connect to (Connection timed out) in /homepages/35/d344059352/htdocs/1dash1/wp-content/plugins/sweetcaptcha-revolutionary-free-captcha-service/library/sweetcaptcha.php on line 81

Want a list of your Business Partners email address for marketing? Email your business partners from your favourite email marketing site by using this report query. It’s SQL that you run from within Query Generator or SQL Server.

Simply copy the code between the /* … and … */ for your version of SAP B1 and paste into the Query Generator.

Here’s something for free! Have a great bank holiday weekend!


SAP Business One SQL Server version –



–Start. Marketing Email List V1.1

select t1.CardCode, t2.cardname, t1.E_MailL

from ocpr t1 inner join OCRD t2 on t1.CardCode = t2.cardcode

and t2.cardtype = ‘C’

–End. Author Stuart Folley  0843 886 1449





SAP Business One HANA SQL version –



–Start. Marketing Email List V1.1

SELECT T1.”CardCode”, T0.”CardCode”, T1.”E_MailL”

FROM OCRD T0  INNER JOIN OCPR T1 ON T0.”CardCode” = T1.”CardCode”

WHERE T0.”CardType” = ‘C’

–End. Author Stuart Folley  0843 886 1449




    Your Name (required)

    Your Email (required)

    Your Telephone

    Your Company


    Your Message