Attaching multiply file to an Email

[Alockhart]

I am sure this has been covered before but I can not find it...

I want to attach multiply files to an email message from Access XP. Problem I am having is that the files names are stored in a table and I am not sure how to get the names from the table so I can attach them in my code.

Thanks
Andrew

 

[PJStephenson]

Andrew
We had fun with this just the other day, have a look and see if it helps: thread705-892005
Peter

 

[Alockhart]

thanks I got it to work..