Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Performance Management
Smart Notification
Two recipients for a single SmartNote email
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
Hitman
Past 24 Hours:
0
Prev. 24 Hours:
0
Overall:
5208
People Online:
Visitors:
296
Members:
0
Total:
296
Online Now:
New Topics
Lawson S3 HR/Payroll/Benefits
Post Tax Benefit Plan Table
11/14/2024 9:16 PM
Hi, totally new to Laswon. I have a repor
Lawson S3 Procurement
ED501 Error: Map 850 not supported by /law/c15vda/lawson/test10/edi/bin/laws_out_91
11/12/2024 3:47 PM
Tried runnning ED501 and getting the atathced erro
Lawson S3 HR/Payroll/Benefits
Error
11/6/2024 9:54 PM
When I try to enroll a retiree in 72.1 health plan
Infor ERP (Syteline)
Syteline: New Data Maintenance Wizard (Error) Need help
11/1/2024 4:24 PM
Hi, I need help with an error on syteline while us
Dealing with Lawson / Infor
Implementing Lawson v10 with Cerner Surginet, Case Cart Picking, and Quick Adds for the OR
10/29/2024 4:20 PM
Hi Everyone, I am wondering if there is any org
Lawson S3 HR/Payroll/Benefits
Canada Tax Calculation (Federal and Provincial) Issue
10/23/2024 5:00 AM
Initially, we had problem with CPP2 calculation is
Lawson S3 HR/Payroll/Benefits
CA Section 125 401k Plan
10/22/2024 10:13 PM
Does anyone have any recommendations on how to fac
S3 Systems Administration
Running AC120 deleted records from ACMASTER table
10/22/2024 3:40 PM
We recently ran the AC120 as normal and somehow it
Lawson S3 Procurement
RQ13 Approval Info
10/17/2024 2:12 PM
When a Requisition is approved on RQ13, what table
S3 Customization/Development
Read and Write CSV file COBOL
10/9/2024 2:53 PM
Does anyone have a quik example of a program that
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3291
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1372
Roger French
1315
mark.cook
1244
Forums
Filtered Topics
Unanswered
Unresolved
Announcements
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
Performance Management
Smart Notification
Two recipients for a single SmartNote email
Please
login
to post a reply.
6 Replies
0
Subscribed to this topic
14 Subscribed to this forum
Sort:
Oldest First
Most Recent First
Author
Messages
Steve Erdman
Basic Member
Posts: 4
12/30/2015 5:58 PM
I frequently hear the complaint, "I didn't get that SmartNote". Sure, I can go into the delivered history and produce a screen print of which SmartNotes were sent, the dates and the recipient's email address, but I cannot view the *content* of what was sent (which would also be great if anyone knows of a way to do that), nor can I say that the email was actually *delivered*. Sure, I can use a UNION query in the Infoset and produce two separate rows and two separate emails with the same content, but I still cannot prove that the first email was delivered or what the content really was.
So one thought was to concatenate two email addresses in the email address of the Infoset, the second email being a separate departmental Inbox that's open to a group of administrators. This would give us an archive of the delivered content and also a little higher degree of confirmation that the email actually came all the way through. I could say, "Well, here's exactly what was sent and you should have received it if your address is valid and you haven't flagged the sender as spam or built any Outlook rules." But I just tried this concatenation in a few different formatting combinations (separating with a semi-colon, comma, spaces or no spaces) and the SmartNote does not deliver.
Anyone have an idea? Sure would be great if there was a cc: field available in the bursting....
Katy Prince
Advanced Member
Posts: 27
12/31/2015 12:24 PM
Not that this is the best way to do this, but what if you sent it to one specific email address and set up a rule in that email box to auto-forward to whomever you want?
John Henley
Posts: 3353
12/31/2015 2:40 PM
Have you tried using an email alias, and assigning multiple users/addresses to the alias?
Steve Erdman
Basic Member
Posts: 4
12/31/2015 3:16 PM
Thanks Katy and John for your replies. Let me give a little more context. This is in a health care setting with about 6,000 employees where we're using SmartNotes to remind them when required clinical certifications or licensures are about to expire. 99% of the time the functionality LBI gives is adequate to respond to the complaint that they never received the reminder, but I'm looking to do several things: A) make it easier for others in HR (who don't have LBI administrative privileges) to browse what's been delivered and to who, B) be able to physically generate what was sent without having to ask IT to get involved with our Exchange Server, C) minimize Exchange traffic.
I like your idea John if it was a small group of recipients who were all allowed to see the same email, but each one is specific to the employee, and if I'm understanding you correctly, the other problem would be scaling this to 6,000 people and maintaining the aliases.
I like your idea Katy, assuming I can write some VBA to dynamically forward the email to the final-destination-email-address embedded somewhere in the SmartNote's content, but I'm not sure I could trust the Exchange server and my code-writing as much as I trust LBI to get it through directly on the first pass.
I was hoping that maybe I could query the LBI back-end for the data. I mean, if I can "redeliver" a SmartNote, everything must be saved in a table somewhere. We've got a "SNUSER" schema and I can run this simple query, filtering as needed:
SELECT *
FROM SNUSER.EMAILHISTORY;
It has a "EMAILCONTENT" column that returns "Blob not fetched" with each row, but as I'm simultaneously typing this and Googling, I see that my SQL editor (Golden32) may have an issue displaying that data. Maybe I can successfully go down this path and periodically dump the contents out into a location others can search. Still not quite my dream solution, but a little better!
John Henley
Posts: 3353
12/31/2015 7:02 PM
I think i understand what you're trying to accomplish, and agree that 6000 aliases isn't going to work
In the bursting setup, there is an option to 'deliver to recipients and copy to devices...'; you could set up a "device" that has an email address, like lsn-copies@example.com. That would effectively cc: that email address for each notification.
Steve Erdman
Basic Member
Posts: 4
1/5/2016 5:55 PM
AHAH! Now we're talkin', John! I'll explore this and update the thread when I get it to work. I believe you're referring to the Notifications Wizard, step 3 Delivery, in the "Select a delivery option" dropdown, choosing "Deliver to the recipients and copy to devices selected on Device tab" after I've configured the new device. It all looks very straightforward. Thank you!
Steve Erdman
Basic Member
Posts: 4
1/5/2016 7:05 PM
Aw shoot - this works perfectly except for one thing - the result is the same as if I add a UNION to my Infoset's SELECT and create an additional row for each record with the secondary email address I want the SmartNote to go to. Two *separate* emails are sent, rather than one with the secondary email address in the cc: line of the email. So close!!! Otherwise, this is a more efficient database hit than a UNION if I want additional recipients of the email - and I do have the benefit of searchable.SmartNote content by non-administrators, so I think I'll move forward with this. Any remaining claim that the SmartNote was undelivered to the intended recipient is better defended. Thanks again!
Please
login
to post a reply.