Search results

could you expand upon this - as it is this line where its "having an issue" ? how would you declare it ? (I am more of a patch it together user tthan an indepth user )

I got the coding from https://christiaanheidema.nl/vba/?Tips_and_Tricks___Saving_e-mails_after_sending I think i will have to re do this to ensure i have not cocked up up

is there an issue with new outlook?

Private Sub QuickEmailSend_Click() Const bq As String = "<blockquote>" Const bqe As String = "</blockquote>" 'Dim mi As Outlook.MailItem 'Dim ID As String 'Dim user As String 'Dim sentAfter As Date 'FileName = ID '### Dim OL As Outlook.Application Set OL = New...

it states 15.02 -as the last patch but i don't believe it - I'll get hold of my network guy ASAP I might slow down the process and see what happens

Doc will revert ...I kicked myself out of my remote access

#it might be outlook it's not running fast- so my code is going faster than outlook and looking for something that might not of been sent (In outbox rather than sent) I will revert one way or the other - I don't have access to Outlook controls -so I need to get my techies to resolve

as an example

Yes its looking for the ID (stored in the catagories in outlook) ID = Format(Now(), "yyyymmddhhnnss") & "_" & CInt(1000 * Rnd()) + 1 ' Save date and time sentAfter = Now() ' Change mail item properties With mi .To = Nz(Me.email) .Subject = Subjectz .Categories = ID

ok the message popped up - so that's one thing (many thanks) - but isn't solving the underlying issue

I will add this in - but just seems weird that its playing up now I will give it a go in 10 mins or so

findSentItem_start: With sfolder ' With olkns.GetDefaultFolder(olFolderSentMail) Set items = .items.Restrict("[SentOn] >= '" & Format(sentFromTime, "ddddd h:nn AMPM") & "'") For Each item In items If TypeName(item) = "MailItem" Then If...

here is the issue bit (been fine for two years or so ) Set mi = FindSentItem(ID, sentAfter) Sentstamp = mi.SentOn ' E-mail has been sent If Not (mi Is Nothing) Then so its going int runtime error 91 : Object Variable or with block variable not set

Hi guys -- been a long time OK I have a email fuction that sudden has a tantrum and comes up with runtime error 91 ... but I have been using this for a couple of years and its only now kicked in this week - any ideas why - I will post the code etc up or should I see if an update has...

That will do it ...but i need coffee before I attempt it - Many thanks - if there is an issue i'll shout.. have a great weekend and if you have a bank holiday enjoy it .

that is excatly what i am trying to achive ..lol

I think that might work

You cannot have a continuous form with a continuous child records. You can have a continuos form with a listbox of the child records this is what I think i am asking using Germany as the example I have a set of data in a continous form where I have selected Germany as the country in...

hello - sorry I justed kick myself out of the network .. I see what you have done - and it wasn't what I had in mind - I have approach already I am trying to move forward/improve on this - (your approach is a lot neater than mine!! ) so looking at how you have this and looking at the...