Search results

No I have this sort - my form Lists everything out - so EUR Dutch tax - will appear only if there are transactions on it in one list box then when i select EUR /Dutch I have another list box that lists all of the transaction that apply to EUR Dutch tax - say 4 transaction 1004...

Odd one background I report on multi currency mutli tax and I have to do a "report" on each so i have created a list box that shows excatly what I want (on the form) Example) EURO Dutch Tax EURO Germany Tax etc.. USD Dutch Tax etc..... ok- Now I want to select any one of them...

yeah - got it it will be xxx (space) xxxxx 7 plus a space (8) one for tomorrow (your input much appricated)

I used Dave as an example - but I will test it shortly its actually the name of a client that is in the email Subject line

sorry yes Post 6 Debug.Print ASC( Mid( sName, 4 + Instr(1, sName, "Dave" ) ), 1 )

OK results ( and I did it from 2 onwards so 2 = 48 3 = 50 4 =49 5 = 32 6 = 48 7= 53 8= 32 9 = 49 10= 57 (I stopped)

Will try ... and come back (Isaac - no Access - but it gets the file name from Outlook (Subject line) )

and I get in the itermediate window S:\xxxxxx\xxxxx\Clients\12245\2021 05 19-223600-FW-Dave .msg S:\xxxxxx\xxxxx\Clients\12245\2021 05 19-223600-FW-Dave(space) space space space .msg so I can see the 4 spaces - if I resend and delete a space to 3 it works ( not that their should be any...

ok I have Public Sub SaveMessageAsMsg() Me.Refresh Dim oMail As Outlook.MailItem Dim objitem As Object Dim sPath As String Dim dtDate As Date Dim sName As String Dim mystring As String Dim trimstring As String Dim enviro As String Dim stFolder As String enviro...

ok this a bit of ponder I have a file save as for Outlook messages (works pretty well) 1 user has had a gremlin and I thinkj I have tracked it down the file save as takes the subject of the email and makes it part of the "save as name" if I do Dave as the subject - no problem if...

This is excatly what I am using - and it does nearly everything

thanks for your response knowing who is logged in only answer half the question as I would still need to know what Outlook profile they are using on occasions I would have Gary using an EU email address and on occasions Gary using an non eu email address I could also have Gary using...

I will try this - as to the filing each record has a folder say 12345 and the way this is set up it will file all emails into this folder on the server rather than filling up outlook (with a Bcc option - I did consider this but outlook would fall over very quickly if 10 users all...

Is the current users email (there maybe two ) and I can then get the code to check that sent folder (sorry for the split note - interent is being wobbly again.. my original problem was called "Minor Meltdown" )

Hi Guys - this is a continuation but seperate from a previous post My users have two accounts and I have email automation to copy rename and file emails (working like a charm-code pinched from somewhere) The issue is that it worksw on default email account - - OK so temporary I...

Ah .. but I want to search their sent emails the above code is just the bit that had the issue the producure - create email send from account ( each user has two accounts EU and non EU) but also a third option which was if a Account Assistant sent an email on behalf of xxx the...

#Sorry not made myself clear OK what I have done is on my form I have "if User Dave and EU = true then use Dave@eutest.com and if Dave and EU = false use Dave@noraml.com" for each user but the Dave is the account exec on the form Susie might send an email from this form - she is...

lol OK - I got this working in a fashion.. but not happy with it - the field on form - I have coded so that it populates the email account on the form - so if it was Dave on the account form then it will check "dave"s email- however I really want it to look at the current user which...

hmmm.. I need to digest ..

Sorry - Todays internet is driving me crazy - its really wobbly (I also mis -read it and thought it said postcode --lol)