Hello all,
Sorry to post on the same subject again but i dont think my last post explained things well enough to convey my problem.
I have written a small project which exports data into a blank database for the purpose of importing into an MSSQL database located on another site. So far i have given the user the ability to have an automated copy to floppy disk option and a partially automated email option. Using the SendObject command i have managed to start the email prog, insert an email address (this only works if it's a valid entry in the users address book), insert a subject title and some body text instructing the user on their next move.
The code i'm using is as follows.
'Email Transfer
Msg = "Do you want to Email the jobs? "
Style = vbYesNo + vbWarning + vbDefaultButton1 + vbSystemModal
Title = "Transfer Via Email"
Help = "DEMO.HLP"
Ctxt = 1000
Response = MsgBox(Msg, Style, Title, Help, Ctxt)
If Response = vbYes Then
DoCmd.SendObject acSendNoObject, , , "Insert Email Address Here", , , "Customer Job Transfer", "Insert the file C:\QEsystem\Exportdata\transfer.mdb to this email & add the required email address.", True
I would really like to tidy this up and have it a lot more professional looking and user friendly, the only problem is that i'm not a programmer and i've never tried this before. However, on the plus side i'm really enjoying this and i really want to learn more.
Regards,
Noel.
Sorry to post on the same subject again but i dont think my last post explained things well enough to convey my problem.
I have written a small project which exports data into a blank database for the purpose of importing into an MSSQL database located on another site. So far i have given the user the ability to have an automated copy to floppy disk option and a partially automated email option. Using the SendObject command i have managed to start the email prog, insert an email address (this only works if it's a valid entry in the users address book), insert a subject title and some body text instructing the user on their next move.
The code i'm using is as follows.
'Email Transfer
Msg = "Do you want to Email the jobs? "
Style = vbYesNo + vbWarning + vbDefaultButton1 + vbSystemModal
Title = "Transfer Via Email"
Help = "DEMO.HLP"
Ctxt = 1000
Response = MsgBox(Msg, Style, Title, Help, Ctxt)
If Response = vbYes Then
DoCmd.SendObject acSendNoObject, , , "Insert Email Address Here", , , "Customer Job Transfer", "Insert the file C:\QEsystem\Exportdata\transfer.mdb to this email & add the required email address.", True
I would really like to tidy this up and have it a lot more professional looking and user friendly, the only problem is that i'm not a programmer and i've never tried this before. However, on the plus side i'm really enjoying this and i really want to learn more.
Regards,
Noel.