Armanino Blog

Dynamics GP Mass Email Set-up Process

March 17, 2016

Dynamics GP can be a very powerful tool for many things, but one of the most overlooked features in GP is its built-in email capabilities. Microsoft has continued to enhance these capabilities in recent versions. Unfortunately, often times the functionality gets buried in areas we least expect to find it. This post covers the process for the Dynamics GP mass email set-up.

The challenge with email settings is that you have to enable it for each customer prior to being able to send out emails. In addition, you need to make sure that each customer has an email address on file in the To: box and you also need to enable email for each company. You also have to set up email templates. The scope of this article is to discuss how to mass edit the customer email settings; it's not intended to be a step by step guide for setting up email.

Let's say you have gone through all the necessary steps to set up email, but now you have 1,000 customers for whom you need to enable email. This is actually much easier than it seems. The first step is to click on "Sales" to open up the Sales Area page and then click on "Customers".

Dynamics GP Mass Email Set-up Process - Image 1

Next, select the customers for whom you want to turn it on. You can either go through the list and select multiple desired customers or check the box next to the customer name column header to select all customers.

Dynamics GP Mass Email Set-up Process - Image 2

Once you have selected the customers for whom you want to enable email, click on the big chevron >> next to the "Modify" buttons and select "E-mail Settings".

Dynamics GP Mass Email Set-up Process - Image 3

Once you click on the E-mail Settings button the, options window will open. Click the Enable check box under "Send Forms as E-mail".

Dynamics GP Mass Email Set-up Process - Image 4

Note: In your environment, only the templates set up in company email settings will automatically be selected so your actual environment may look a bit different from the example.

Once you are ready to mass apply the changes, click the OK button. You should see a confirmation at the top of your Navigation list saying "Email Settings action completed" with the number of success and failures.

Dynamics GP Mass Email Set-up Process - Image 5

One final note if you are not seeing the E-Mail Settings when you select multiple customers and click on the >> next to Modify, you will need to refresh your SY07240 table in SQL. To do this, perform the following.

***Make a backup of your DYNAMICS database prior to running this query!!!! If you are not comfortable running SQL statements then please contact your partner or Microsoft support. ***

  1. Launch SQL Management Studio
  2. Select the DYNAMICS Database and click on the "New Query" button
  3. In the query window type in (without the quotes) "DELETE DYNAMICS..SY07240" and click on Execute
  4. Log back into GP and launch the Navigation list and follow the blog post again. GP will automatically rebuild this table with the correct options and you should now see the E-Mail settings button.

That's all there is to it! Mass modifying email settings will save you a lot of time.

Check out more GP blogs for additional tips and tricks like the Dynamics GP mass email set-up to discover how to make the most of your GP system.

Stay In Touch

Sign up to stay up-to-date with the latest accounting regulations, best practices, industry news and technology insights to run your business.

Related News & Insights
Building Beyond: Exploring Construction Trends for Growth
How to Build a Better Foundation for Your Company

June 13, 2024 | 10:00 AM - 10:30 AM PT
2024 Digital Marketing Trends – What's Now, What's Next?
Stay up to date on the latest trends and strategies in digital marketing.

May 30, 2024 | 11:00 AM - 11:30 AM PT
Risk Mitigation Measures: Navigating Disruption with Confidence
Is your business at risk from unseen dangers?

May 29, 2024 | 12:00 PM - 01:00 PM PT