Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[Michael Bartlett]

?We use Outlook and email directly from the PO transaction window. Recently a user started getting an “Unknown Error” window when generating an email with a PO to certain vendors. We traced that to an address in the “cc” field of the email message belonging to another user who just left the company and had been removed from both Exchange and the GP user base. It appears that the message setup saved the former user’s name and/or email address in the “cc” field, causing the process to fail. Removing the entries from “cc” allows the email to be created and sent.

We’re not sure how many vendors are affected and we know we can modify each one individually. I looked through all the PM tables trying to see where that information is stored to see if there’s a way to script removing former users from the message setup, but didn’t see anything useful.

If anyone has run across this or can direct me to where SQL stores this it would be good to know.

Thanks,

Michael H. Bartlett
Quantum Marine Engineering of Florida, Inc.
954-587-8361
mbartlett@quantumhydraulic.com

——————————
Michael Bartlett
Quantum Marine Engineering of Florida, Inc.
Fort Lauderdale FL
——————————

[Bruce Strom]

The email info is in table coINetAddrs.

/****** Script for SelectTopNRows command from SSMS ******/
SELECT [Master_Type]
,[Master_ID]
,[ADRSCODE]
,[INET1]
,[INET2]
,[INET3]
,[INET4]
,[INET5]
,[INET6]
,[INET7]
,[INET8]
,[Messenger_Address]
,[INETINFO]
,[EmailToAddress]
,[EmailCcAddress]
,[EmailBccAddress]
FROM [AGINC].[dbo].[SY01200]
where [Master_Type] = ‘VEN’

——————————
Bruce Strom
Programmer Analyst
Associated Grocers of Florida
sunrise FL
——————————
——————————————-

[Bruce Strom]

replace AGINC with your company database, of course

——————————
Bruce Strom
Programmer Analyst
Associated Grocers of Florida
sunrise FL
——————————
——————————————-

[Michael Bartlett]

?Thank you Bruce, perfect.

I appreciate the help,

——————————
Michael Bartlett
Quantum Marine Engineering of Florida, Inc.
Fort Lauderdale FL
——————————
——————————————-