Recent content by djshrew

1. Create a query 2. Create a button on your form. 3. added this code behind the button. Private Sub Command55_Click() On Error Resume Next If MsgBox("This will email all contacts in the database. Continue?", _ vbExclamation + vbYesNoCancel) = vbYes Then Dim strMailList As...

OK FIXED all the issues ;) To fix the problem with there being no email address under a contact i based it on a Query. Query just contained email addresses. in the query i added.. Like "*@*.com" Or Like "*@*.co.uk" Or Like "*@*.net" Or Like "*@8.biz" Or Like "*@*.us" Or Like "*@*.org" Cannot...

Attached is the latest copy. which does work as i want it to as long as all the email address fields are filled out. However if u remove one the whole thing stops working. So if u create or have a contact with no email address the whole mailshot stops working.

Ok after spending hours on this i have a solution.. Private Sub Command125_Click() On Error Resume Next If MsgBox("This will email all contacts in the database. Continue?", _ vbExclamation + vbYesNoCancel) = vbYes Then Dim strMailList As String, rs As Recordset Set rs =...

think i found a solution, but i have no idea how to implement it. http://www.jephens.com/2007/05/13/how-to-send-e-mail-from-ms-access-using-outlook/comment-page-1/ i would like to use the loop function attached to this button (See Attached.)

Thanks JR, i will give this a try. --- Edit --- Added a pic of the error message it get, sure i am doing something stupidly wrong as i am no access expert. I get error2.jpg first, then error.jpg

I maybe wrong, but it is possibly the VBA behind the command button. prehaps set to "acNormal" and should be "acFormDS" for what you want? Futher info here... http://www.datawright.com.au/access_resources/access_docmd.openform_arguments.htm

does anyone know how i can mail all contacts in this database?

the button mail all, i would like it to mail all the contacts in the database. but dont want it to attatch anything simple added them to the To: line in the email so i can attatch items and compose the email manualy without having to add all the contacts into outlooks address book. In short i...

I am trying to add a feature so my client can mail all the contacts, but i am drawing blanks. the mail single client is fine, but i would like to mail all. dont need to attach anything just add all the mail contact to the to: line in word or outlook. Thanks Den

How can i make my reports only show me 5 days from a date of the report. Date i want to work form is. "EmployeeDateFrom" control Source. I want to show where that employee was that week. Thanks in advance. Sorry if not explained very well i am rubbish at access.

Hi all. I have a database, which is a simple customer database. which has the ability to make lables for customer who have a yes in the combo box. what i would like to do is create a mail shot for those customers also. by a single click button. i already have a email address field and i also...

Found a great page actually.. might be good for others. so here it is: http://www.databasedev.co.uk/split_a_database.html

Could someone please explain, how you would do a front end back end? do you have forms in DB 1 (Front end.) And tables in DB 2 (Back end.) Where would the reports and that go? front or back? or am i completely wrong? and what are the benifits of a front/back split? networking? Thanks in...

Sorry this never came to anything in the end. i will see what point i got to and see if i can bring this back to life. altho i am not sure that the requirement is still needed, but i will message both you guys if it is required and you can bid.