By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,956 Members | 1,722 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,956 IT Pros & Developers. It's quick & easy.

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

P: 19
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:
Expand|Select|Wrap|Line Numbers
  1. Private Sub Command6_Click()
  2. Dim subject As String, Body As String, Email As String
  3. Email = [Text99]
  4. subject = [Text0]
  5. Body = [Text1] & Chr$(13) & [Text2] & Chr$(13) & [Text3] & Chr$(13) & [Text4]
  6.  
  7. DoCmd.SendObject , "Send an email", acForm, Email, , , subject, Body, False
  8.  
  9. 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!
Aug 27 '08 #1
Share this Question
Share on Google+
3 Replies


missinglinq
Expert 2.5K+
P: 3,532
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)>
Aug 27 '08 #2

P: 19
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!!!
Aug 28 '08 #3

NeoPa
Expert Mod 15k+
P: 31,342
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?
Aug 30 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.