Mass Delivery - No Document Type
Hi,
I need to send individual plan text emails to a list of addresses returned via a Sql query.
I have tried using Email report Action and SQLMulti but it placed all addresses in the TO field, I need a separate email for each address.
I think Mass Delivery might be an option but it seems to want to link it to an SAP Document, which wouldn't be appropriate for this.
Are there any work arounds or options to achieve this ?
Many thanks :)
Comentarios
4 comentarios
Hi Mr Cooper,
I would suggest looking into the Custom Mass delivery. This would allow you to create your own SQL statement, which could pass as DocKey@ to your email action
Thanks! I did manage to get it working in a fashion with the following Configurations - I've included an image if anyone needs something similar. Send Mass delivery without document or report to list of customers.
If i wanted to modify to send to a custom list of emails returned by the SQL (not the Default Contact Person) - how would i do that?
also, “UI - Form Type” says it is optional when clicking the question mark - but wont allow me to save without something ?
Hello,
For this you would need to use Direct Mail with SQL: SELECT …. where "CardCode" = DocKey@
So it would depend on whether you can create a SQL based on only the dynamic cardcode, which is passed on by the DocKey@ variable. Can you share what the email address query would look like?
ah amazing, that helped a lot! think we have cracked it…
- you can just drop DocKey@ directly into Direct Email field on the report action and have it populate DocKey@ with anything you like from the SQL - in this case the required email address! - thanks for all your help :)
Iniciar sesión para dejar un comentario.