Unique attachments

[twalishuka]

Hi there,



I am trying really really hard to accomplish something, but I need help.

I am creating a database where files are attached from a default folder, based on the surname. For example, I want to email a school report (saved as a PDF) for John to John's mother and John's father.

Please can you give me some guidance? This would help me a lot...

Alistair

[jgelpi16]

How do you have the surname identified? Do you have the user select the surname or type it in? Depending on how you have your file name set up you can identify the file by using the Dir() function.

vSurname = "Smith"
Dir("C:/Data/File" & vsurname & ".pdf")

Without a little more to go off of I'm not sure I can be much help.