VictorAtWork
Registered User.
- Local time
- Today, 02:03
- Joined
- Oct 16, 2015
- Messages
- 10
Hello,
We have tried several of the forum replies to no avail with outlook.
Here is our scenario:
We provide certificates of completion to attendees of a classroom course.
We print these certificates using a loop based on the state they live in AND if they have additional certifications.
This all works fine.
We now have our sub sending the reports out to a folder (c:\exportPDF) in PDF format.
This is working fine.
What we want to do now is take the associated PDFs for the attendee and attach them to a single email.
The reports are assigned the studentid as the identifier + what type of certificate it is.
Example: 10101_ak.pdf for a state certificate, 10101_cfp.pdf for an advanced certificate.
Some attendees may have 1 certificate, some may have more - depending on how many certifications they hold.
We have been able to send each certificate in an individual email. Not a good solution as the attendee may receive 5 emails - each with one pdf.
We are at a point now that the loop attachs the first pdf, then gets the first and second pdf, then gets the first, second and third pdf. The attendee would receive the number of emails that there are certificates, just like sending one email for each certificate, but the last email would have all the pdfs.
Since the uniqueness of the file is the studentid we are hoping someone can point us in the direction of being able to search the exportPDF folder and attach all pdfs for the attendee to one email. We are using the studentid as a variable and declaring it.
Again, understand that we have read the forums, tried many of the solutions suggested but have not been able to get ALL the pdfs for the attendee to attach to ONE email.
Thanks for you help in advance.
We have tried several of the forum replies to no avail with outlook.
Here is our scenario:
We provide certificates of completion to attendees of a classroom course.
We print these certificates using a loop based on the state they live in AND if they have additional certifications.
This all works fine.
We now have our sub sending the reports out to a folder (c:\exportPDF) in PDF format.
This is working fine.
What we want to do now is take the associated PDFs for the attendee and attach them to a single email.
The reports are assigned the studentid as the identifier + what type of certificate it is.
Example: 10101_ak.pdf for a state certificate, 10101_cfp.pdf for an advanced certificate.
Some attendees may have 1 certificate, some may have more - depending on how many certifications they hold.
We have been able to send each certificate in an individual email. Not a good solution as the attendee may receive 5 emails - each with one pdf.
We are at a point now that the loop attachs the first pdf, then gets the first and second pdf, then gets the first, second and third pdf. The attendee would receive the number of emails that there are certificates, just like sending one email for each certificate, but the last email would have all the pdfs.
Since the uniqueness of the file is the studentid we are hoping someone can point us in the direction of being able to search the exportPDF folder and attach all pdfs for the attendee to one email. We are using the studentid as a variable and declaring it.
Again, understand that we have read the forums, tried many of the solutions suggested but have not been able to get ALL the pdfs for the attendee to attach to ONE email.
Thanks for you help in advance.