1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

MS Access Sending an Email

Discussion in 'Business Applications' started by nursell, Feb 2, 2013.

Thread Status:
Not open for further replies.
Advertisement
  1. nursell

    nursell Thread Starter

    Joined:
    Jul 26, 2011
    Messages:
    143
    Hi,

    Everyday i import customers parcel tracking numbers into my database. Once they are in the database i write a query that pulls the the customers email address and the tracking number, that works fine but now i need to send them all an email with there tracking numbers.

    The email is a standard to everyone the only difference is the tracking number and obviously the email address.

    Take a look at the example database, i need to email everyone in the query.

    Can anyone help me with the VBA?

    Thank you.
     

    Attached Files:

  2. OBP

    OBP

    Joined:
    Mar 8, 2005
    Messages:
    19,895
    What emailing software is going to be used?
     
  3. nursell

    nursell Thread Starter

    Joined:
    Jul 26, 2011
    Messages:
    143
    Outlook 2003
     
  4. OBP

    OBP

    Joined:
    Mar 8, 2005
    Messages:
    19,895
    The VBA code would have to send individual emails to the recipients, in which case the Security will be a major issue.
    You will need a program like "ClickYes" to automatically answer the security question for each email.
     
  5. nursell

    nursell Thread Starter

    Joined:
    Jul 26, 2011
    Messages:
    143
    Yes thats fine
     
  6. pdebaets

    pdebaets

    Joined:
    Feb 4, 2013
    Messages:
    1
  7. OBP

    OBP

    Joined:
    Mar 8, 2005
    Messages:
    19,895
  8. nursell

    nursell Thread Starter

    Joined:
    Jul 26, 2011
    Messages:
    143
    Brilliant i will take a look.

    Thanks
     
  9. nursell

    nursell Thread Starter

    Joined:
    Jul 26, 2011
    Messages:
    143
    Hi OBP,

    i have looked at your sample database it is very good, but it is not what i need. If i try writing the code my self, can you help me?

    Thanks.
     
  10. OBP

    OBP

    Joined:
    Mar 8, 2005
    Messages:
    19,895
    I know that the database is not what you need, but the emailing VBA code should have the elements that you need ie
    A loop through a query or table recordset, assigning of a field value to the body of the message, sending the email via Outlook.
    Of course I will help you tailor the VBA to your needs.

    PS, sorry I see that one uses Word. the other one that would have the elements you need (except it puts all the recipients in the BC or BCC) is this one.
    http://forums.techguy.org/business-applications/967851-sending-date-alarm-alert-outlook-19.html
    at post #278.
     
  11. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1087891

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice