VBA: Automatically send emails in a loop with different attachments

[NeoSez]

I am trying to figure out the best way to send bunch of emails to different recipients along with a different attachment for each person.
So, currently, I have this below. How do I modify the attachment script to choose from the same line as the contacts list?

.Display
.To = toemail
.CC = ccemail
.subject = subject
.HTMLBody = body & .HTMLBody
.Attachments.Add tempFilename

Contact	List ID	Email address	CC Email	Attachment
Pablo Lobster	2	pablo@hunger.com	me@menu.com	recipe.pdf
Elvira Crabs	3	elvira@cooks.com	Pol@pots.com	crabs.pdf

 

[NeoSez]

Never mind. I figured it out.

 

[Peter_SSs]

Good to hear you got the solution.
If you would like to post the solution then it is perfectly fine to mark your post as the solution to help future readers. Otherwise, please do not mark a post that doesn't contain a solution.

 

[cwstudio2020]

I think this may help you.

How to Quickly Distribute Report Files to Each Recipient Individually