Create Individual PDF file for attachment based on data in excel

Good day dears!

I am looking for a macro that can create a letter based on data provided in excel, save this letter as individual PDFs and attached it in an email. Have found a sample workbook and tried to modify it according to my needs, however, the rest of the letter is not being copied in the PDF created and the 2 pictures should be visible as well. Also need to ensure that if column C is the same for any rows, it should only create one email which contains all data in column B. Subject of email should be "Letter Template + whatever data is in column C"

I have attached the macro i found plus the sample pdf that should be attached in the email.

Hope somebody can help me here... Looking forward to all your expert assistance.

Thank you in advance!!

hello Melody,

the first issue you need to take a look at is your loop. see the image. it is not running, because the start counter is greater than the end counter. so your emailing function is not even being called....

the thing is i just copied entirely the code from some file here... can you help me fix the error please?

Originally Posted by melody10

the thing is i just copied entirely the code from some file here... can you help me fix the error please?

well I'm sure you did. I would encourage you to learn the stuff that you download. if you do too much of that, you could find yourself in trouble, without much help at your fingertips. here's some assistance, since you asked. you have many issues going on. the PDF name is obviously not what you want (see image 2 below). the person you are sending it too as well, is incorrect (see image 1 below). so, clarification is certainly needed on both of these blocks of words from you, in terms of what you're looking for:

e rest of the letter is not being copied in the PDF created and the 2 pictures should be visible as we

Also need to ensure that if column C is the same for any rows, it should only create one email which contains all data in column B

there is nothing in column ''c'' that is indentifying in nature. the image is sitting on top of the grid, it is not in any given column.

thank you dear for taking that time to check.. as you noticed, i am very new in VBA and hence would appreciate if your could help me, maybe create a new file from scratch?

basically the general requirement is to create 1 email with a PDF attachment, for every unique data in column C (sheetname: ALL STAFF (PAYSLIPS))

1. PDF attachment should be updated as per details found in the same sheet. have highlighted all in yellow the fields that must be updated.
2. PDF attachment should have include 2 images, a logo on top of the letter and a stamp at the lower section

Melody,

since maniacb has joined here, I will see what he has to offer you does what you need. get back to everyone and let us know what happens and what questions come up after that. if all else fails, I'll do some work for you. why not...

To send one email for duplicate count, you are looking for duplicates in Column C, not emails column G? How many duplicates do you expect to have at once? More than 2? Up to how many?

I made changes to support up to four duplicate bill of ladings

it's perfect!!!! well.. almost... i am not really sure how many is the maximum duplicates in column C is possible in the future. is it possible to edit it to change the number of maximum duplicates? but for now this is workable from me. i really appreciate your help!!

vba_php... super thank youu for your time in checking my concerns..

really big help from you both

I didn't help. but okie dokie! LOL

hello maniacb... sorry found one issue on the macro... when there are the same email address (in column G), it just generating 1 pdf / email. it should create 1 email per booking number (column C). so if [email protected] has 5 bookings, he should received 5 different emails, with 5 different attachments. can you help?

hope i explained my self well.

Sure, I assumed each booking number had a one to one relationship with the email. I need to do some rearranging. You should see an improved solution by tomorrow.

Here you go

super super thanks!!! perfect!!