How do I set up mailings by dates? - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

How do I set up mailings by dates?

Hello. I have a simple "Carpet Cleaning" Access database that I am
working on. It has a Billing Address, Site (of carpet cleaning),
Service Date and Details of Cleaning tables. My friend wants to be
able to send mailings to his customers. He also wants to be able to
have a way to control monthly, every 3 months, every 6 months, 9
month and yearly. (He asks the customer when they would like a
reminder for the next cleaning to be done.

I have "some" experience with VBA. I assume there must be some kind
of query I could use.

Thanks for your help.

Fred
[email protected]




Comments

  • gigsvoogigsvoo Posts: 328Member
    Just build an application, store the next reminder date in the last or new column inside the table.

    Everytime when the system runs, check the columns of date compare with the sytem date...

    : Hello. I have a simple "Carpet Cleaning" Access database that I am
    : working on. It has a Billing Address, Site (of carpet cleaning),
    : Service Date and Details of Cleaning tables. My friend wants to be
    : able to send mailings to his customers. He also wants to be able to
    : have a way to control monthly, every 3 months, every 6 months, 9
    : month and yearly. (He asks the customer when they would like a
    : reminder for the next cleaning to be done.
    :
    : I have "some" experience with VBA. I assume there must be some kind
    : of query I could use.
    :
    : Thanks for your help.
    :
    : Fred
    : [email protected]
    :
    :
    :
    :

    Neo Gigs
    http://communities.msn.com.my/VisualBasicwithNeo


  • gigsvoogigsvoo Posts: 328Member
    Just build an application, store the next reminder date in the last or new column inside the table.

    Everytime when the system runs, check the columns of date compare with the sytem date...

    : Hello. I have a simple "Carpet Cleaning" Access database that I am
    : working on. It has a Billing Address, Site (of carpet cleaning),
    : Service Date and Details of Cleaning tables. My friend wants to be
    : able to send mailings to his customers. He also wants to be able to
    : have a way to control monthly, every 3 months, every 6 months, 9
    : month and yearly. (He asks the customer when they would like a
    : reminder for the next cleaning to be done.
    :
    : I have "some" experience with VBA. I assume there must be some kind
    : of query I could use.
    :
    : Thanks for your help.
    :
    : Fred
    : [email protected]
    :
    :
    :
    :

    Neo Gigs
    http://communities.msn.com.my/VisualBasicwithNeo


Sign In or Register to comment.