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