0
Good day, I am an absolute newbie at using any form of scripting or programing so please forgive me if I don't provide enough information or context.
I need to email around 1000 PDF documents a day to various recipients.
We receive a request with a unique 9 digit reference number. Each request is logged in a table which details the requestors email address and the reference number generated. We then process the order and save the invoice with the same 9 digit reference number as a pdf. I then need to open outlook, attach the relevant document (named with the reference number), add the relevant email address in the To: field, from the table. Copy and paste a standard worded message and send to the client.
Doing this manually ofcourse takes time, and in some instances results in errors, eg. reference number 1 gets sent to the wrong receipient.
we cannot add any new programs other than outlook to handle the process. Any and all advice is appreciated.
Thanks in advance.
TheConfusedCFO
Posted 2014-06-26T13:02:27.387
Reputation: 1
Have you tried just using mailto link to setup the subject line? Without the ability to add programs what you want likely isn't possible with your level of permissions. – Ramhound – 2014-06-26T13:06:34.477
That does work but still requires me or the user to manually enter in the email address. thats kinda where it goes a bit pear shaped. one user emailed invoices to a clients competitor showing their preferential discounts. you can imagine the outcome :) – TheConfusedCFO – 2014-06-26T13:15:43.893
@Ramhound If i were to get admin rights etc, what could i do to make this happen? – TheConfusedCFO – 2014-06-26T13:20:01.567
You can use something like Excel to cancatenate different cells to generate a link easily enough. – Ramhound – 2014-06-26T13:31:45.137