One-Button Email Dump

  • Thread starter Thread starter Barbra Lehto
  • Start date Start date
B

Barbra Lehto

I need to create a feature in a database app whereby the user can press a button and a .csv file comes out. The user needs to periodically update their email addresses using the ones in the database, and I want to make the process as transparent as possible to them.

I have a table and an update query all setup and tried to use a macro to accomplish all of the steps, but the macro language doesn't include the Export command, only the OutputTo, which does not let you output to a ..csv.

Is there a relatively transparent way I can get all of this done?

Thanx
Barbra
 
G'Day Barbara,
Now USUALLY it is easier to PULL rather that PUSH!!
If the Users normally use Outlook for e-mail, then you
should probably attach a VBA Module with a Procedure
that:
Opens the Database,
cycles through their Contacts
For each Contact
checks the e-mail address
updates Outlook if required
Closes the Database AND
Indicates to WhoEver that the Update was successful.
A VBA Procedure is quite capable of this!
--
Regards,
Pat Garard
Australia

Anne & Pat Garard.
apgarardATbigpondDOTnetDOTau
_______________________________________________
 
Wow! Sounds great! I haven't the foggiest notion how to do it.

Can anyone help?

I am not a programmer--I'm kind of a "programmer lite"--I'm a stay-at-home mom doing some work for a local women's group. I'm pretty good with Access and a number of other software applications, but have little experience with VBA.

Thanks
Barbra

"Pat Garard" <apgarardATbigpondPERIODnetPERIODau> wrote in message G'Day Barbara,
Now USUALLY it is easier to PULL rather that PUSH!!
If the Users normally use Outlook for e-mail, then you
should probably attach a VBA Module with a Procedure
that:
Opens the Database,
cycles through their Contacts
For each Contact
checks the e-mail address
updates Outlook if required
Closes the Database AND
Indicates to WhoEver that the Update was successful.
A VBA Procedure is quite capable of this!
--
Regards,
Pat Garard
Australia

Anne & Pat Garard.
apgarardATbigpondDOTnetDOTau
_______________________________________________
 
Back
Top