Search results

Sorry I'm not familiar with the terms BE nor FE.

This one. It's a server so I didn't try to reinstall the office because they use access and other programs, couldn't mess much.

I did all that work for Outlook and then found out that they cant run Outlook on their PC, some error pops-up of which im not yet sure about what, but I do suspect the Username of the windows being in special characters coz I tried quite some solutions, nothing worked. So at the end I used CDO...

Fixed it with this. Public Function GetTextFileContents(sFilePath As String) As String If Dir(sFilePath) <> "" Then Dim objStream, strData Set objStream = CreateObject("ADODB.Stream") objStream.Charset = "utf-8" objStream.Open...

I'm trying to add a html file data to the .HTMLBody. I'm using a function to read the file data .HTMLBody = GetFileData(PathOfFile) Well, it adds my signature and all the formatting but characters like ć, č, š... mess up. Also, it doesn't add the image I have in the html file but the characters...

Ok I found a function which checks if Outlook is opened, if not Outlook will open minimized and I like that. I implemented it and now it works good, at least for now :D Code was writen by MVP Ben Clothier and I found it on this site: Test if Outlook is open and open Outlook with VBA #Const...

How about this? Private Sub cmdSendEmail_Click() '20190403 Dim MyRs1 As Recordset Dim FileName As String Dim emailText As String Dim outApp As Outlook.Application Dim outMail As Outlook.MailItem Dim myInspector As Outlook.Inspector Set outApp =...

Well, not really. I could use it just thought it would be more fancy everything being done in the background. I could put into a msg box to keep an eye on the outbox or sth. I can use the shell ("OUTLOOK") to show the outlook if not opened already?

The_Doc_Man, well I do need an attachment and a signature tho, is it possible?

These are the settings, I tried ticking the "Perform an automatic send/receive when exiting" but same.

I did comment it out, same. How exactly do I check those settings, Im using outlook 2007?

In the recordset Im testing it on, 2 of 3 emails always get sent just the last one not unless I put a delay before the End Sub. And I never see the Outlook window with the Set myInspector = .GetInspector and it does put the signature I tested it, so I actually dont need the .Display for the...

By using this function I found Public Function Pause(NumberOfSeconds As Variant) On Error GoTo Error_GoTo Dim PauseTime As Variant Dim Start As Variant Dim Elapsed As Variant PauseTime = NumberOfSeconds Start = Timer Elapsed = 0 Do While Timer < Start +...

Hey guys, Im having trouble with Outlook not sending all emails, after the code below is executed. The Outlook application is closed most of the time before I start the code and that will be usually the case, when its opened all emails send normally after the code execution. However, as I said...

:o :o That was it, darn how I miss those simplest things :banghead: A sharp eye u have :) Thanks!

I cant get to export my report as PDF with the OutputTo command. First I was getting another error that it was not supported if I remember right and found out an add on which has to be installed from microsofts wibsite. https://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=7...

I do need to export the same report to PDF at another button click but with different filter this time. DoCmd.OutputTo acOutputReport As I see here I cant put a filter? :( So seems I will have to go for another solution.

Yes was a typo, thanks. Alright, I checked the link and created a variable which contains the WHERE condition and added it to the report open filter code. It works as I wanted it to, nice :) Are there any downsides to this? Thanks!

Is there way to add a temporary criteria to a queries field, that query is used for a reports record source. I do have a code which changes one of the queries criteria into another, using .Parameters, something like this. Set MyQry = MyDb.QueryDefs("qryQuery1")...

I need to order by a field which contains some names, so a text field. The problem is that I have some characters like ć, č, š..and so one which we use in our language. When I use the normal order by feature in report design it orders it well but sometimes it does this: Current order: S###...