Sending Email

[mlyles]

If I were making changes to a form and I wanted to send an email by clicking the command button and I want a box to pop up saying send with changes or send without changes so that it would either record the changes that I have made or not. How would I go about doing this? Also lets say I wanted to send the whole database file but instead of sending it .mdb I want to send it .md_ because it will not allow me to send a .mdb file because of the size. Is there anyway I can create a command button and send the whole file .md_?
Thanks for the help.

 

[Liv Manto]

"If I were making changes to a form and I wanted to send an email by clicking the command button and I want a box to pop up saying send with changes or send without changes so that it would either record the changes that I have made or not. How would I go about doing this? "

Use the msgbox function Yes or No, if yes, save your changes in a table.

You can create a table where you have fields:

ID of record Change; fieldname; OldValue of the field; New Value of the field.

Append your changes to this table.



"Also lets say I wanted to send the whole database file but instead of sending it .mdb I want to send it .md_ because it will not allow me to send a .mdb file because of the size. Is there anyway I can create a command button and send the whole file .md_?"


Even if you send it as md_, wouldn't it have the same size?

Are you using Outlook from a command button in Access ? You can probably zip it first before sending.

 

[mlyles]

"Use the msgbox function Yes or No, if yes, save your changes in a table.

You can create a table where you have fields:

ID of record Change; fieldname; OldValue of the field; New Value of the field.

Append your changes to this table."

How would I go about doing this so that the box shows up when I want to mail the form.

 

[Liv Manto]

If the question is 'How to create a msgbox", the Access Clip can help you.

If the question is "Can you give me the code?" You have to send me your database.