Need help with conditional email attachments (was Please help!)

[atlanteavila]

Hello all,

I've got a database that is used to register couples preparing to get married in our Church to a class named Pre-Cana, we collect couples personal infomation along with email addresse, I recently created a database for this using access. The database works fine but my quesiton is concerning email with attachments.

Every time a couple registers for a class, we send them a confirmation email welcoming them to the class along with an attachment letter stating that they've paid. We have several classes in one year and each letter changes with the respective class. i.e. Welcome to the October 19th class for pre-cana! or Welcome to the November 10th class for pre-cana.... Is there a way to automate this proccess using access and groupwise? I have this code being called from a button which sends an email based on a form:

Private Sub Command6_Click()
Dim subject As String, Body As String, Email As String
Email = [Text99]
subject = [Text0]
Body = [Text1] & Chr$(13) & [Text2] & Chr$(13) & [Text3] & Chr$(13) & [Text4]
 
DoCmd.SendObject , "Send an email", acForm, Email, , , subject, Body, False
 
End Sub

Is there a way I can send an attachment based on the date of the Class? or a way to serch files to attach directly from Access?

Thanks in advance for all your help!

[missinglinq]

Please remember to provide a meaningful Title for any threads you start! This helps to ensure that our members understand what your problem is about, and that they and also the general public will have a better chance of finding answers to similar questions. It is difficult for the experts to answer questions when there is not enough details provided to understand the problem.

Because of this, I have given your thread a new title.

Please take the time to read the Posting Guidelines, paying particular attention to Give a clear title to your question.

Thank you and Welcome to Bytes!

Linq ;0)>

[atlanteavila]

Please remember to provide a meaningful Title for any threads you start! This helps to ensure that our members understand what your problem is about, and that they and also the general public will have a better chance of finding answers to similar questions. It is difficult for the experts to answer questions when there is not enough details provided to understand the problem.

Because of this, I have given your thread a new title.

Please take the time to read the Posting Guidelines, paying particular attention to Give a clear title to your question.

Thank you and Welcome to Bytes!

Linq ;0)>

Will do. Sorry about that and thanks for the help in changing the title so I can get better replys!!!

[NeoPa]

It's possible to change the subject, or even the body of an e-mail. I don't know anything about GroupWise, but the subject and the body are both strings and these can be manipulated in VBA.

Obviously you would need to have access to the information you want to use, but we can't really help much with that as we don't know your situation very well (You've told us very little of it).

Where would you have this information as to which class the recipient is being welcomed into?