Share
ReportdI need to update all existing customer that have an email address to use the doc type of word to now be pdf. Is there a script to do this?
You’re offline. This is a read only version of the page.
1,455
dI need to update all existing customer that have an email address to use the doc type of word to now be pdf. Is there a script to do this?
Hi Deborah,
Please see the update on 9/22 for the recent Word Template issue from an Office update. You should see the SQL script there.
community.dynamics.com/.../word-templates-will-not-email-print-after-office-update
Thanks
Hello Deborah,
All of the customers and vendors are held in the SY04905, with the EmailDocumentFormat being the type of document sent, with 1 being DOCX and 3 being PDF.
Here is a script that swaps everyone over to PDF:
UPDATE SY04905 SET EmailDocumentFormat = '3'
If you want to filter on Customers VS Vendors, then you can filter on EmailSeriesID. If you want to filter further there are other options:
EmailSeriesID – 3 (for Sales) & 4 (for Purchasing)
MODULE1 – 9 (for SOP), 11 (for Receivables), 12 (for POP) & 19 (for Payables)
Hopefully this gets you going in the right direction.
As always, have a backup before you do anything in SQL!
#1
André Arnaud de Cal...
291,703
Super User 2024 Season 2
#2
Martin Dráb
230,433
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (
