Sending data via email

  • Thread starter Thread starter Don
  • Start date Start date
D

Don

Each of my sales people will have a database on their laptops. The database
will run via runtime. I want to be able to email them a text file of data
that I'd like them to be able to upload into the database on their laptops.

Can I do this? How would I write the VBA Code? The text file would be a
fixed width text file. I'd appreciate any help you might be willing to give
me. Thanks...
 
You can link the text file and use it as a table in your database. If
the text file never changes name, the file can be overwritten and the
link will still work provided the database is not open when the file
is overwritten.
 
Hi Don,

Just setup the file with each of them and link it in in the section tables.
That every future update, just ensure you use the same file name & format.
All they have to do is right click your file and select: save as... (and
overwrite your template-file)
That's all they have to do as you can easily jot some lines of VBA code
against an action and with queries, running at that certain action (e.g. form
load) your updates are applied without them knowing.

Rgds
Cloggy
 
consider emailing them an excel sheet.

with an unvarying format, unvarying file name - you can instruct them to
always save it into the same unvarying location... overwriting the old one
each time....

then it can be considered a table linked from Access... and you don't have
to do anything more...
 
Don,

Check out the SendObject method for sending the email with the text file to
the recipients. Then, checkout the TransferText method for the way to import
that data from that file into the users database.

If you are really ambitious, you could use Automation to check the
recipients Outlook inbox for a file with a particular subject and an
attachment. If it finds an email with this particular combination, you could
automatically save the attachement to a particular location on your the
individuals system and then use the TransferText method to import the data
into your application automatically.

HTH
Dale
 
dans l'article
(e-mail address removed), n00b à
(e-mail address removed) a écrit le 22/01/08 7:52 :
 
Back
Top