to: albany
subject: albany 6/5 Thu Ship
body: albany 5 loads.
i assume this is coming from your database?

possibly you can use ADO to read data directly from the data base, but user choices (without userform) may be more difficult
or maybe the better alternative is to select the attachment from the userform, using some criteria to make it easier to select, based on folder and file date