| Emailing options for Microsoft Great Plains | | | | especially in attachment. SA impersonates in |
| version 10.0 and earlier: 9.0, 8.0, 7.5, 7.0, | | | | windows admin, so you should not trust the |
| 6.0, 5.5 could be programmed in SQL Email | | | | testing of using sa if you plan to email pdf |
| feature. However there are serious security | | | | attachments. |
| considerations you should be aware of. | | | | |
| Customizing Microsoft Dynamics GP as the | | | | 4. SQL user id impersonalization. Well, in |
| internal activity is not easy one, and then | | | | case of Great Plains Dynamics GP user id is |
| you need automatic emailing, we recommend to | | | | really SQL login, propagated to DYNAMICS and |
| you check with specialists. In this small | | | | company databases. And considering the fact, |
| article we would like to concentrate on SQL | | | | that attachment should be authorized by |
| mail or xp_sendmail extended stored | | | | Windows domain user, you have to imprersonate |
| procedure: | | | | SQL login. We spent few hours with Microsoft |
| | | | technical support to make that happen, |
| 1. MAPI client setup on your SQL Server 2005 | | | | however at this time, December 2007, |
| or 2000. This is relatively easy task. You | | | | Microsoft SQL Server 2005 seems to have this |
| should run your SQL server service under | | | | as internal bug |
| domain account, which will be setup in | | | | |
| exchange to email your stuff from Great | | | | 5. Attachment security work around. |
| Plains, more likely Accounts Receivable | | | | Obviously the format of this tiny article |
| account, if you plan to email invoices to | | | | doesn't allow us to give you all the source |
| your customers. Just install Microsoft | | | | codes, however we are happy to give you the |
| Office Outlook 2007, 2003 or 2000 - they'll | | | | hint right in the article - please consider |
| do the job - you don't really need the | | | | creating SQL Server job to run emailing |
| "power" of Outlook 2007 | | | | procedure (we'll give you the code) with SA |
| | | | user credentials |
| 2. Adobe PDF writer. It is not enough to | | | | |
| install third party free PDF printer | | | | 6. Linux and UNIX customers. If you deploy |
| emulation programs, you will need genuine PDF | | | | Redhat or another Linux or Unix solution, you |
| writer to generate PDF form of your invoices | | | | can try to import PDF files created in |
| from simple customized Microsoft Great Plains | | | | Windows Microsoft Dynamics GP logic to your |
| Dexterity application - please check with us, | | | | Linux solution and do invoices emailing from |
| we have this Dex customization let's say | | | | there |
| "solution", as it is not an off-the-shelf | | | | |
| product. PDF writer is required if you plan | | | | 7. eConnect, C# and VB.Net approaches. |
| to email letters to your customers, where you | | | | Technically xp_sendmail could email Crystal |
| will be attaching invoices in PDF format | | | | Reports version, GP ReportWriter and PDF |
| | | | files, in the solution we propose you try out |
| 3. Security. XP_SENDMAIL works under SQL | | | | PDF format, and if you need further logic |
| security realm. If you use sa for testing, | | | | advancements, we are here to help you. |
| it might not work for regular GP users, | | | | |