Guys,
I need a tool that can
Email mail merge but also (and here's the curve ball) attach a PDF document with mail merged fields within it i.e. the PDF contains also mail merged fields which are addressed to the email recipient.
It's not so critical that the email itself has mail merge fields. The challenge is tying up the email attachments to the email recipients which seems a real bitch - if it was just a boggo email, we could just use Word or Sage ACT or similar... Our FDO has (for unknown reasons) stated the formal letter itself must be received as a PDF attachment, despite advice against (the attachment may not reach, or may be held up by email filters etc....)
Anyone got any smart ideas? Despite being in IT for ten years, this is a tricky one
Obviously confidentiality to recipients is also key, so the exposure of email addresses must be zero to each recipient (i.e. it only appears that it was sent to them, and them only). There can be no email address exposure.
I want to try and avoid scanning these formal letters into a PDF and then sending them individually, which will take some considerable time as there's hundreds and hundreds.
Appreciate any wise pointers
Thanks.