Hi Everyone, I was wondering if anyone can help wi...
# general
k
Hi Everyone, I was wondering if anyone can help with an issue I'm having: Upper management wanted a daily email sent out to upper management employees that's a table for each Sales Channel showing Yesterdays Order, Invoices, and Last Years Orders. We have 2 other tables but for MTD and YTD. This has been created already from an Email Template and all fields were manually created and placed on the Vendor Prepayment record, and a workflow was created to store their values. Using @MGBC method here (which is brilliant) https://www.mavencloud.tech/blogs/post/send-emails-to-dynamic-recipient-lists I created a workflow to send these 3 tables every day to about 14 employees. It was working perfectly getting the emails every day, but recently it's been buggy where it doesn't send one day but will another. Or it won't send for a couple of days but then the next day it will send. Is it because I'm adding more people to the send list? I wouldn't think it was because of that. Here's what I've checked so far and it wasn't the solution: 1. Everyday it shows on the "Sent Email List" 2. I don't see it on the "Undelivered Emails" 3. I can set the workflow on testing and Execute the workflow and it will send the email to everyone. 4. Does it have to do with the DKIM or my company having it's own Spam email protection on our Outlook accounts? I've asked them to whitelist anything coming from NetSuite before and that solved a previous issue and plus my testing of this workflow works and other Scheduled emailed reports and saved searches work perfectly fine. It's just recently this one that's been buggy. I'm currently waiting for a call back from Support, but any help is greatly appreciated!
a
I suspect spam protection may be a factor here, but It seems to me like once a day shouldn't trigger spam protection. But just in case that is the problem, my current employers were advised to make sure that at least the Subject of each email was different each time it gets sent to the same recipient. I don't actually remember if this fixed it but it's the last thing I remember trying. Just in case this could fix it, you can make the subject of each email unique by putting a field reference in the subject (type it out, don't paste, if you're doing this in the Workflow Action -- pasting adds invisible HTML that makes it seem to the workflow action like it should be literally {thinginbrackets} instead of a field reference. Use a field combination that will be different every time, such as the current date and time. So the subject could be something like
Copy code
Sales Channels Summary as of {today} {now}
I'm not sure if I got those references correct but I think you get the idea. ({today} should work. I don't know if {now} does, off the top of my head). I don't know if this will fix your problem but if the recipients are under a mail server you have control of or admin access to, then maybe you can troubleshoot whether it's rejecting the email on the next day.
❤️ 1
While your company might have spam protection, I think NetSuite also tries to protect itself from being listed as a source of spam, but then if that was applied to any of those outgoing messages, it should mark the emails as Not Sent or Not Compliant or something.
❤️ 1
k
Hi @Aaron McCausland! Thank you so much for the reply. I'll give that Subject reference a try as I know that helped with another issue I had with NetSuite blocking email sent because it was triggering it as spam. I did get off the phone with Support and they also mentioned it most likely has to do with our internal Spam Protection. Which is weird because when I test the workflow it sends out every time and other scheduled reports/SS work every time no issue. I emailed our IT department about it and hoping this was the solution.
👍 1
m
Hi @Koon Kabob did you check the workflow logs on the record to see if the action was executed properly?
Also the send.email module does have some limitations are you extending past any of these?
❤️ 1
k
Hi @MGBC! Yes the logs do say it was Executed as well. Our IT department did get back to me and the issue was our Outlook Spam filter. We whitelisted the NetSuite domain and it's working back to normal again! Thank yu again for all your help. You and your website have helped me a lot and you deserve many thanks! :)
1
m
@Koon Kabob that's great to hear...glad some of our posts have been helpful. Keep an eye out after the holidays we've got lots of cool articles planned for next year! Happy Holidays!
❤️ 1