VBA to automatically collect data through E-mail

[Tom1]

Hello,
I currently collect data from e-mail for my db. However to do this repetitavely I have to go into manage replies > Resend this e-mail message, then go through the wizard to send the e-mail out. Is there a way in VBA to do these steps automatically with the code being assigned to a button on a form?

[alcapps]

if you are trying to send an email.. try
docmd.SendObject(acSendQuery,"qryName",acsendtype, "Toemailaddress","ccemailaddress",,"subject","mess age")

[Tom1]

Hello,
That code works fine to view / change / reply to my e-mail and then I update the db. I want the reply from the e-mail to automatically update the data in the db without the need for me or the user to open the db up.

[alcapps]

i'm not sure I understand what you are asking.
You want an email reply to update the database with opening the database?

you can create a macro that will be called from a scheduler Windows task. That macro could go and look for an email and import the attachments without anyone doing anything. It would take a lot of vba coding. All of which you can find. I have done this many time.
you will need to look for outlook vba code from ms access.