Search results

Slick! I might do this just because it is better than a recode.

Yes, correct - I just need to work on the replace placemarkers bit.

Thanks for this. I thought of breaking it up into its component parts in the table and and building it at runtime but given that it is only one or two variables, the Replace() part looks simpler and easier to handle. Its great that I have sorted this out as it gives me much more flexibility with...

Thank you, I will try that out. Sounds like it will work since I only have two variable to replace.

I haven't got it working but I did get the isolation of the issue which is that the copy from the table to the HTMBody is not working out. So I know that I need to to find a different way. I don't know about placeholders and Replace() functions and I will investigate that. If you have any...

The way I have it is that each email my system sends is stored in a table. The body of the email is stored in both text format and html format. The code just picks up the html formatted text from the relevant record (identified by the autonumber) using a DLookup function and puts it into...

Yes, that is correct - EmailID is the location in the table of the particular record

Hmm. OK. I think I can figure that out. Basically I need to take the text from the table and run it in VBA to get the variables to populate, then put it in html. Thanks. That should work

The variables have content - I checked that. I usually call my variables with a vbl prefix - a hangover from my initial learning to code on an Apple II

The message comes out fine, just the variables don't display the content. Maybe it is something to do with storing the message in a table.

The text is stored in a table and looks like this: <p>A new regulation " & vblRegulation & "has been published and, in order to ... The Code looks like this: With MailOutlook .BodyFormat = 2 .To = vblLegal '.cc = "" '.bcc = ""...

I tried this as well but it didn't work - just showed text " & variable & " text. The ampersands actually showed up like that.

I am sending email using HTMLBody. I want to insert variables into the body of the text but the variables don't display. Is it possible to display a variable and what is the syntax, if it is? I have tried <var> & variable & <\var> but it just italicised the name of the variable and didn't...

I want to email a hyperlink to selected persons. The hyperlink points to a corporate intranet and the only recipients are internal so the email should allow it. The hyperlink is stored in a table as a hyperlink and the code pick it up and puts it in the .html of an email. It all works fine until...

I don't unfortunately have test data I can put up. The results of this query will show me a count of counterparties with a "Yes" status and the count will all show a number 1 or higher. If I change the status to "Active" it will still show numbers of 1 or higher. What I need is to show all those...

I am hoping someone can tell me what I am not seeing here. I have a contract register. In simplistic terms one table tracks the counterparty. Each counterparty has a Current field which has a Yes/No list. There is also a contract table which lists the contracts and which has a one to many...

Thank you. This worked perfectly!

Is there a reasonably simply way to convert a query to as sql statement and insert that into the rowsource of a listbox programatically? I have several queries for one list box and I swop them out according to the need to look at different information. I want to rather have a sql statement in...

OK. Solved it. You have to change the Totals line to "First" and not "Group By". Judging by the comments there are many ways to solve this issue - some work one way and some another. For me, for this issue it has been to change the totals to "First"

I am sure that there is something I should be doing but it is just beyond what I can remember. I have Long Text (O365 version) fields in my reports but it cuts off after what I assume is 255 characters. Both field and section is set to can grow and shrink. How do I fix this?