how can I Send the data from Access using an emailing system?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm doing this project and as part of that project i need to be designing my
system using microsoft access so that it would enable the sending of the most
updated data each week to this other office using the emailing system. can
some please make suggestions on how i would be able to make my access system
to do so? thanks
 
The big question is do you want to automate Outlook specifically for sending
these e-mails, or any installed MAPI compliant e-mail program?

If the latter, you can use Access' built-in SendObject command (Microsoft
Access Email FAQ - SendObject:
http://www.granite.ab.ca/access/email/sendobject.htm) to send a query,
table, etc. via e-mail. However, you don't have full control over the e-mail
message.

If the former, and you want full control, automate the Outlook Object Model
in your Access project to create, populate and send the e-mail. See this
link for more info:

Microsoft Access Email FAQ - Outlook:
http://www.granite.ab.ca/access/email/outlook.htm
 
DON'T GO OUT OF YOUR WAY TO DO IT THAT WAY.

INSTEAD LOOK UP THE MS FEATURE 'TRACK CHANGES' &| MSDN
SQL &| USE THE EXPORT FEATURE. CREATE A MAILING LIST.
EACH MAIL MESSAGE WILL HAVE TO BE MANUALLY SENT AT THIS
TIME.
 
Roshni said:
I'm doing this project and as part of that project i need to be designing my
system using microsoft access so that it would enable the sending of the most
updated data each week to this other office using the emailing system. can
some please make suggestions on how i would be able to make my access system
to do so? thanks
Click to expand...

Eric and anonymous thanks for your help and anonymous can you please explain
more on how to do the thing you've written in your reply e.g. where do i need
to go and what do i need to do (a step by step procedure). thanks
 
Back
Top