Search results

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.

Thank you so much, this worked perfect. Database complete so no more stupid questions for now.

any chance you could post this database as an example? and possible post your fix for people to look at if they have a similar problem. Thanks Den

Ok i am nearly done, I have the first set of addresses setup perfect. the problem i have is instead of the report automaticaly using the right hand side, of the spread sheet it goes onto another page. Not the best picture sorry but as you can see it uses the left fine, how can i make it use...

I have a Query which i have set a filter on, I then turn the Query into a report. but when i view the report the filter withing the Query has not stuck so it deplay all the data instread on the filetered version of the Query. Why is this? or can this not be done? Thanks in advance. Shrew...

This looks interesting thank i will try this later. as this would work nicer, altho i have the basic thing working so far. but would make a cleaner image, Thankyou. Den