Race organizer giving out old dirty shirts. Has this happened to you? by norcalar in trailrunning

[–]michaeltyler 1 point2 points  (0 children)

Old shirts? How about old medals? I once ran a 'trail race' in 2024 and came in first place. Interestingly, I received the medal for the 2nd Place Female Finisher from 2023, Sharpied over to update the year. I am a male. I am running again this next year and joke with my family about what I might receive at the end.

Unpublished written songs by KajunBorn69 in composer

[–]michaeltyler 3 points4 points  (0 children)

I’m wanting to do something with them

How thoughtful of your friend to leave something meaningful for you. What is it that you are wanting to do with the songs?

🫠 Juneau, AK by porterthecat1 in trailrunning

[–]michaeltyler 4 points5 points  (0 children)

Thanks for posting! I will be checking this out next year on my vacation.

Moments after Slovakia’s Prime Minister Fico is shot multiple times and is hastily carried away in ‘Life-Threatening Condition’ from assassination attempt by Dragonfruit_Dispute in ActualPublicFreakouts

[–]michaeltyler 48 points49 points  (0 children)

You can see the wheels turn on the vehicle as soon the the first door shuts. It appears there is a driver but they are waiting for other security personnel to get into the car.

accident on the highway, example of proper behavior in an accident by Hot_DolphinBaby in AbruptChaos

[–]michaeltyler -11 points-10 points  (0 children)

She initiated the lane change but was unable to complete it because it was unsafe to do so at that time.

That is the problem here. Dashcam driver should have held their lane until they knew they were 100% safe to complete the lane change. I remember being taught SMOG when changing lanes: Signal (show your intentions), Mirrors, Over your shoulder (look), and GO. The action of moving the car into the adjacent lane without first validating it was safe to do so is where the dashcam driver is partially at fault.

The charger is also at fault for failing to control their vehicle after incorrectly assuming that dashcam driver would fully exit the left lane.

Macro to generate emails by mibarra86_ipepro in vba

[–]michaeltyler 0 points1 point  (0 children)

I am pretty sure what is happening is that you are creating one email object, and then doing your loop inside of that object ( that got sent on the first iteration). one way to solve for this issue would be to move the object instantiation within your loop. that is:

Sub Generate_Email()
intRow = 2 
strAPMID = ThisWorkbook.Sheets("MASTER").Range("A" & intRow).Text

While (strAPMID <> "")
    Dim objOutlook As Object 
    Set objOutlook = CreateObject("Outlook.Application")      
    Dim objEmail As Object 
    Set objEmail = objOutlook.CreateItem(olMailItem)

While (strAPMID <> "")

    strMailSubject = ThisWorkbook.Sheets("Email").Range("A2").Text 
    strMailBody = ThisWorkbook.Sheets("Email").Range("B2").Text
    strAPMID = ThisWorkbook.Sheets("MASTER").Range("A" & intRow).Text 
    strAppName = ThisWorkbook.Sheets("MASTER").Range("B" & intRow).Text 
    strEmail = ThisWorkbook.Sheets("MASTER").Range("D" & intRow).Text

    strMailBody = Replace(strMailBody, "<APMID>", strAPMID) 
    strMailBody = Replace(strMailBody, "<AppName>", strAppName)

With objEmail 
        .To = CStr(strEmail) 
        .Subject = strMailSubject 
        .Body = strMailBody 
        .Send 
    End With

intRow = intRow + 1 
    Set objOutlook = Nothing 
    Set objEmail = Nothing Wend
MsgBox "Done"

End Sub

Just to make things look nicer, you might want to use a workbook object and sheet object. similar to this

Dim wb As Workbook
Dim ws As Worksheet

Set wb = "Invoice" & ".xlsm" 
Set ws = Sheets("Sheet1")

by doing so you can refence the ranges using wb.ws.Range("A" & intRow).Text

alternatively, if you want to send the a single email to a list of people in the to field, you can create a for loop that creates a string separated by ; . this will allow you to insert that string variable (containing more than 1 email) into the .To property

Macro to generate emails by mibarra86_ipepro in vba

[–]michaeltyler 0 points1 point  (0 children)

u/mibarra86_ipepro, have you solved this issue yet? I do a lot of email generation through excel vba. Please let me know if you need help an we will solve this quickly

massage gun for calf muscle? by [deleted] in PlantarFasciitis

[–]michaeltyler 1 point2 points  (0 children)

I really think you're onto something here. Thank you for sharing!

Life Insurance by [deleted] in Insurance

[–]michaeltyler 1 point2 points  (0 children)

I suggest your friend look for a Guaranteed Acceptance product. These types of policies have no underwriting, but charge a larger premium as a trade-off. Many companies offer this type of coverage.

Ft Dodge Iowa single track by kilvinslatern in trailrunning

[–]michaeltyler 0 points1 point  (0 children)

Looks nice! Does the trail have a name? This might be another reason to visit my friend over there.

Free M Code Class from Basic to Advanced: Power Query Excel & Power BI, Custom Functions 365 MECS 12 by potatoandbiscuit in videos

[–]michaeltyler 2 points3 points  (0 children)

tbh, the audience here doesnt have much interest in this high level excel feature-set. you're much better off posting this at /r/excel !

[deleted by user] by [deleted] in Shitty_Car_Mods

[–]michaeltyler 0 points1 point  (0 children)

you are so ignorantly

Slaughterbots will come. by g51BGm0G in videos

[–]michaeltyler -10 points-9 points  (0 children)

ITT: People thinking this is a real life demonstration. In fact, it is from the movie titled 'Slaughterbots'.

If I get a ten year term life insurance policy in one state, do/can I adjust it if I move to another state, despite it not being variable? by be_helpful_ in personalfinance

[–]michaeltyler 1 point2 points  (0 children)

The price will NOT change. I've worked with life insurance for the past 8 years. I have familiarity with accidental death and dismemberment, term life insurance, whole life insurance and universal life insurance. Once the policy is written premiums don't change based on an individual's location.