Generating Replies via e-mail.

[HenriM]

I am distributing an Accesss Application which requires that, at a certain point, users e-mail back to me certain details in a file "Mail Permissions.xls". The code is:-

[DoCmd.SendObject acSendReport, "Mail Permissions", acFormatXLS, "instantprofile@comptonit.com", , , "Free Client"]

The problem is that this generates a message via Microsoft Outlook and, for those with other ISPs, requires setting up a new Microsoft Mail Account. Many users employ software engineers to set up their systems and even for those who "roll their own" it would be an unnecessary nuisance. They need to send through their existing e-mail account without hassle.

Why don't I just ask them to send me an e-mail? Well, if the procedure is written into the program they can't move to the next stage until that e-mail has been sent - which is what I am aiming for.

Maybe I am trying to do the impossible in which case I would like to know so that I can try another way of skinning the cat. But if anyone has any ideas it will be a great help.

Thanks

 

[HenriM]

RE my message - of course, the information to be sent to me is in a Report "Mail Permissions" set up in tabular Format - not an .xls file!!!!

Sorry about that!

 

[HenriM]

Following again on my last two messages; I have looked right through "Advanced Search" and can still find nothing which equates to my problem - which I should perhaps restate in slightly different terms.

I am distributing an application which has certain free facilities but, at a certain point requires Users to register. They do this by clicking a "Send" button on the Registration Form in the Access Program. I do not know at that stage who they are and what their e-mail set-up is. It could be AOL,Compuserve, or any one of 100 ISPs.

SendObject ....... would by default direct their response to Microsoft Outlook and it would be counter-productive to expect them to set up a special account just for that one message - remembering that they are now running the program and sending back to me.

The nearest article I can find is Steven Wynkoop's "Mail- Enabling Your Microsoft Access-Based Application". Seeing this title I thought Christmas had come early but found that the article covers only MAPI.

I am drawn to the conclusion that it is not possible in VBA to create a procedure which directs SendObject to their existing default e-mail account and ISP. So it looks as though I shall have to ask them to go back to my Website, fill in a Registration Form there, and, on receipt, send back a password which enables them to continue.

For me the SendObject route would be neater and would enable them to carry on using the program without interruption. So if it can be done, some indication of the path to follow would be much appreciated. If it can't then confirmation of this would also help.

As my old Boss (a former Intelligence Officer in SOE) used to say, "Confirmation is as good as information."

Again, Thanks in anticipation.