Search results

oh i got a wee bit click happy and added wee extra bits to it so heres the final thing! It works if you save it to your "My documents" or whatever. have fun playing and working it out Millions of thanks to everyone that helped ... not going to list you all incase i forget someone, by mistake...

Heres the wee thing now!:eek: :o :p :rolleyes: :rolleyes: :rolleyes: :rolleyes:

how fantastic are you... If i could kiss you i would! thanks more than a million! it works!!! WOOOOOOOHOOOOOO! YEY YEY YEY!!:D :D :D :D :D know what though next time im going to climb Ben nevis (much easier):p was thinking if i took the cd then started a new database on the companies...

Thanks very Much! Im just off to try that now! Had to go in to the shop and pay the wages and do the stock counts and money and stuff this morning first but im on the case now... thanks so much for your help! Can you lot use the Database i have attached??

still stuck and i have just tried to burn what i have to cd and guess what! its set to read only and wont allow me to set it any different!! cant fix that either!!! so so close yet so (swear word) far! I already put this off by a couple of weeks and they are expecting it today now!!! ...

I am still working on this but I am totaly shattered now so think i'll head to bed! the code i have posted above works to some extent... it does the attachment and all but it doesnt pass over all of the email addresses.... just the last one I have done the tryal and error thing by putting...

Private Sub Email_Click() Dim rsEmail As DAO.Recordset Dim strFilter As String Dim strInputFileName As String Dim strEmail As String strFilter = ahtAddFilterItem(strFilter, "All Files (*.*)") strInputFileName = ahtCommonFileOpenSave( _ Filter:=strFilter, OpenFile:=True, _...

:mad: :mad: :mad: :mad: how frustrating is this:mad: :mad: :mad: :mad: still cant get it to work.

Where are you assigning the email? ??? dont know what you mean??? sorry :o Where are you sending the email? I am sending the email to some contacts. e.g. 200 construction contacts. Email.Display just shows the email..it does not send it. Thats actually OK with me as it gives them a...

this is looking good! been working on it over the weekend and there is one bit i cant get.. i have used all the different ways and mixed them together and stuff but im stuck again...last problem :rolleyes: :p hopefuly what i have done is set up a list box based on the same qry that my subform...

if you have a productID for your products would that not help? e.g. single sheet on its own has a code of 1 a pack with a single sheet and pillow case has a code of 2

thanks ill try that now!

would EmailSend.Bcc = forms!frmSelect2Email!tblContacts_subform1!Type + ";" work for sending the message??? no??

is there anyway i can change the code in the button in bucks form from EmailSend.To = "email@somewhere.com" to EmailSend.To = (the field in the subform on frmSelect2Email then loop through them all... not getting asked to send every time OR putting the same field in the bcc section with a ...

Hay! Thanks a million... and everyone else i have learned so much by looking at what you have done, still working out how some of the code works but it looks good.

...

error message has just started to come up?? MSACCESS caused an invalid page fault in module KERNEL32.DLL at 017f:bff7a138. Registers: EAX=09206e60 CS=017f EIP=bff7a138 EFLGS=00010206 EBX=0743f09c SS=0187 ESP=00626b9c EBP=00626bd0 ECX=6d20756f DS=0187 ESI=0743f028 FS=0e97 EDX=20656b61 ES=0187...

Sorry honey! didnt mean to mail you everytime. is selecting a different file everytime a problem? it will usualy be html file but poss not always. Hay thanks a million for helping sorry you got all the tests :o :p :eek: gotta luv me ???:D Ill try out some different things now on sending...

Thanks shadez! Hay thats still not working at this end when i click on the email button i get a grey screen saying that a program is trying to send an email on your behalf... the to: is empty and subjest says subject then it has send or dont send... if i click on send a time line thing comes up...

thank you very very much honey! im going to go to an internet cafe now to try and use OUTLOOK!! seen as though im not allowed to here! ill be back!