PSWriteHTML - Emailimo module - not saving htmlFile

[javadbacker]

I'm sorry for the Noobish question below. Thanks a lot for the module and we had communicated on the emailimo module issues section and you had helped me out earlier as well.

Previously I had a working script with Emailimo module only. Now that emailimo is part of PSWriteHTML, I am having an issue with having the htmlFile saved with the below script.

Due to some reason, the htmlFile is not getting updated with below script mainly the
Email -FilePath $htmlFile -WhatIf

function RUN-emailimo_forWeeklyProgressReport {
	
    Install-Module -Name PSWriteHTML -Force -Scope CurrentUser 
    Import-Module PSWriteHTML -Force
    Import-Module Emailimo -Force

    # $script:test = Email -Supress $false  { # 
    Email -FilePath $htmlFile -WhatIf { # 

        EmailHeader {
            EmailFrom -Address 'myAddress@gmail.com' 
            EmailTo -Addresses 'toAddress@company.com' 
            EmailServer -Server 'smtp.office365.com' -UserName 'myAddress@company.com' -Password 'myPassword' -SSL
            EmailOptions -DeliveryNotifications Never -Priority Normal
            EmailSubject -Subject $email_Subject
        }
        EmailBody -FontFamily 'Calibri' -Size 15 {
            EmailText -Text "All, $currentTime"  # , $UserNotify, "," -Color None, Blue, None -Verbose -LineBreak
            EmailText -LineBreak
            EmailText -Text "Please see below the progress on deliverables for the project. Detailed document status is attached."
            EmailText -LineBreak
            EmailText -Text 'A.	Activities done during current week' -TextDecoration underline -FontWeight bold
            EmailText -LineBreak
            EmailTable -Table $new_activitiesDoneDuringCurrentWeek_DataTable -HideFooter   # -DisableInfo -DisablePaging -DisableProcessing
            EmailText -LineBreak
			
            EmailText -Text 'B.	Forecast Activities for the next week' -TextDecoration underline -FontWeight bold                             
            EmailText -LineBreak                                                                                                              
            EmailTable -Table $new_forecastActivitiesForNextWeek_DataTable -HideFooter   # -DisableInfo -DisablePaging -DisableProcessing
            EmailText -LineBreak
			
            EmailText -Text 'C.	Progress Summary' -TextDecoration underline -FontWeight bold
            EmailText -LineBreak
            EmailTable -Table $new_cseProgress_dataTable -HideFooter   # -DisableInfo -DisablePaging -DisableProcessing
            EmailText -LineBreak
			
            EmailText -Text 'D.	Man-hour summary' -TextDecoration underline -FontWeight bold
            EmailText -LineBreak
            EmailTable -Table $new_manHourSummary_dataTable -HideFooter   # -DisableInfo -DisablePaging -DisableProcessing
            EmailText -LineBreak
            EmailText -Text 'E.	Remarks & Concerns ' -TextDecoration underline -FontWeight bold
            EmailList -FontSize 15 {
                EmailListItem -Text 'Discussions on modular frame re-use ongoing.'  
                EmailListItem -Text "Current Productivity is $([math]::Round($productivity,2))"  
            }
            EmailText -LineBreak
            EmailTextBox {
                'Thanks & Regards'
                'Name'
            }
        }
    }
	
    Write-Log -Message "SENDING EMAIL with email_IMO" -Path "$WeeklyProgressReportsFolder\Script.log" -Level Info 
    Write-Log -Message "test.Status $($test.Status)"  -Path "$WeeklyProgressReportsFolder\Script.log" -Level Info 
    Write-Log -Message "test.SentTo $($test.SentTo)"  -Path "$WeeklyProgressReportsFolder\Script.log" -Level Info 
    Write-Log -Message "test.Error  $($test.Error)"   -Path "$WeeklyProgressReportsFolder\Script.log" -Level Info 

}
RUN-emailimo_forWeeklyProgressReport

[string]$htmlFile_AsString = Get-Content $htmlFile

function compose-OutlookEmail {

    $outlookFolderDrafts = 16
    $outlookObject = New-Object -comObject Outlook.Application 
    $nameSpace = $outlookObject.GetNameSpace("MAPI")

    # call the save method yo dave the email in the drafts folder
    $mail = $outlookObject.CreateItem(0)
    $null = $Mail.Recipients.Add("manager@company.com")  
    $null = $Mail.Recipients.Add("lead@company.com")  
    $Mail.Subject = $email_Subject 
    $Mail.HTMLBody = "$htmlFile_AsString"
    $mail.Attachments.Add($Source);
    $Mail.importance = 2 
    $Mail.save()

    # get it back from drafts and update the body
    # $drafts = $nameSpace.GetDefaultFolder($outlookFolderDrafts)
    # $draft = $drafts.Items | where {$_.subject -eq $email_Subject}
    # $draft.body += "`n foo bar"
    # $draft.save()

}
compose-OutlookEmail 

[PrzemyslawKlys]

Ye, it seems i've broken Whatif parameter somehow. You can revert to older version of PSWriteHTML/Emailimo.

[PrzemyslawKlys]

New release is published.

Uninstall-Module Emailimo -AllVersions
Update-Module PSWriteHTML

Also, consider

replacing:

    Install-Module -Name PSWriteHTML -Force -Scope CurrentUser 
    Import-Module PSWriteHTML -Force
    Import-Module Emailimo -Force

With:

    Import-Module PSWriteHTML -Force

It's not healthy to use install-module without testing first. Also uninstall emailimo as it's no longer needed.

[javadbacker]

Hi thanks will check it out 👍👍

[javadbacker]

Hi I have done the following

Uninstall-Module Emailimo -AllVersions
Update-Module PSWriteHTML

Also replaced

    Install-Module -Name PSWriteHTML -Force -Scope CurrentUser 
    Import-Module PSWriteHTML -Force
    Import-Module Emailimo -Force

With:

Import-Module PSWriteHTML -Force

Also didn't use the -WhatIf parameter in Email function

But got below error

The script failed due to call depth overflow.
    + CategoryInfo          : InvalidOperation: (0:Int32) [], ParentContainsErrorRecordException
    + FullyQualifiedErrorId : CallDepthOverflow

[PrzemyslawKlys]

Which line? Did you restart PowerShell after installation?

[javadbacker]

Version    Name                                Repository           Description                                                                                                                                                                                  
-------    ----                                ----------           -----------                                                                                                                                                                                  
0.0.3      Connectimo                          PSGallery            Simple connectivity project                                                                                                                                                                  
0.0.105    PSSharedGoods                       PSGallery            Module covering functions that are shared within multiple projects                                                                                                                           
0.86       PSWriteColor                        PSGallery            Write-Color is a wrapper around Write-Host allowing you to create nice looking scripts, with colorized output. It provides easy manipulation of colors, logging output to file (log) and n...
0.0.63     PSWriteHTML                         PSGallery            Module that allows creating HTML content/reports in a easy way.  

Installed modules above
I didn't restart after installation

[PrzemyslawKlys]

PSWriteHTML doesn't require those other modules anymore. It's standalone. You should reopen powershell thou.

[javadbacker]

Ok. I have reopened Powershell.

The depth overflow error occurs at below line

Email -FilePath $htmlFile {
.
.
}

[PrzemyslawKlys]

I can't reproduce it. Can you provide some reproducible code?

[javadbacker]

Get-InstalledModule

Version    Name                                Repository           Description                                             
-------    ----                                ----------           -----------                                             
0.0.63     PSWriteHTML                         PSGallery            Module that allows creating HTML content/reports in a...

Below code produces

# Import-Module PSWriteHTML

function copy-ManHourSummaryTo_manHourSummaryDataTable {

    $script:manHourSummary_dataTable = New-Object System.Data.DataTable
    $manHourSummary_dataTable.Columns.Add("Description", "string") | Out-Null
    $manHourSummary_dataTable.Columns.Add("ManHours", "string") | Out-Null
	
    $r = $manHourSummary_dataTable.NewRow()
    $r.Description = "Estimated Man-hours at Award"; $r.ManHours = "10000"
    $manHourSummary_dataTable.Rows.Add($r) #add the row to the table

    $r = $manHourSummary_dataTable.NewRow()
    $r.Description = "Additional Man-hours (MOC & DTCMS)"; $r.ManHours = "1000"
    $manHourSummary_dataTable.Rows.Add($r) #add the row to the table

    $r = $manHourSummary_dataTable.NewRow()
    $r.Description = "Total Man-hours Approved"; $r.ManHours = "11000"
    $manHourSummary_dataTable.Rows.Add($r) #add the row to the table
	
    $r = $manHourSummary_dataTable.NewRow()
    $r.Description = "Actual Man-hours spent last week"; $r.ManHours = "1000"
    $manHourSummary_dataTable.Rows.Add($r) #add the row to the table
	
    $r = $manHourSummary_dataTable.NewRow()
    $r.Description = "Cumulative expended Man-hours"; $r.ManHours = "5000"
    $manHourSummary_dataTable.Rows.Add($r) #add the row to the table

    $manHourSummary_dataTable
    $script:new_manHourSummary_dataTable = $manHourSummary_dataTable | Select-Object -Property Description, ManHours

}
copy-ManHourSummaryTo_manHourSummaryDataTable


$dateStringForReportDateInProgressSheet = $reportDateInProgressSheet.ToString("yyyy-MMM-dd")
$email_Subject = "PROJECT PROGRESS REPORT FOR THE WEEK"
$productivity_String = "Current Productivity is 1.01"
$currentTime = get-date

$script:htmlFile = "C:\hmtlFileFolder\htmlFile.html"

function RUN-emailimo_forWeeklyProgressReport {
	
    # Install-Module Emailimo -Force -Scope CurrentUser
    # Uninstall-Module Emailimo -AllVersions
    # Install-Module PSWriteHTML -Force -Scope CurrentUser
    # Install-Module -Name PSWriteHTML -Force -Scope CurrentUser # -AllowClobber -Force
    Import-Module PSWriteHTML # -Force -Scope CurrentUser
    # Import-Module Emailimo -Force
    "imported module"
    
    Email -FilePath $htmlFile  { # -WhatIf

        EmailHeader {
            EmailFrom -Address 'myAddress@gmail.com'
            EmailTo -Addresses 'myAddress@myCompany.com'
            EmailServer -Server 'smtp.office365.com' -UserName 'myAddress@myCompany.com' -Password 'myPassword' -SSL
            EmailOptions -DeliveryNotifications Never -Priority Normal
            EmailSubject -Subject $email_Subject
        }
        EmailBody -FontFamily 'Calibri' -Size 15 {
            EmailText -Text "All, $currentTime"  # , $UserNotify, "," -Color None, Blue, None -Verbose -LineBreak
            EmailText -LineBreak
            EmailText -Text "Please see below the progress on department deliverables for the Offshore project. Detailed document status is attached."
            EmailText -LineBreak
            # EmailText -Text 'A.	Activities done during current week' -TextDecoration underline -FontWeight bold
            # EmailText -LineBreak
            # EmailTable -Table $new_activitiesDoneDuringCurrentWeek_DataTable -HideFooter   # -DisableInfo -DisablePaging -DisableProcessing
            # EmailText -LineBreak
			
            EmailText -Text 'D.	Man-hour summary' -TextDecoration underline -FontWeight bold
            EmailText -LineBreak
            EmailTable -Table $new_manHourSummary_dataTable -HideFooter   # -DisableInfo -DisablePaging -DisableProcessing
            EmailText -LineBreak
            EmailText -Text 'E.	Remarks & Concerns ' -TextDecoration underline -FontWeight bold
            EmailList -FontSize 15 {
                EmailListItem -Text 'Load out for FooBar module arrangement discussions ongoing.'  
                EmailListItem -Text "Current Productivity is 1.01"  
            }
            EmailText -LineBreak
            EmailTextBox {
                'Thanks & Regards'
                'JB'
            }
        }
    }
	
}
RUN-emailimo_forWeeklyProgressReport

[string]$htmlFile_AsString = Get-Content $htmlFile

function compose-OutlookEmail {

    $outlookFolderDrafts = 16
    $outlookObject = New-Object -comObject Outlook.Application 
    $nameSpace = $outlookObject.GetNameSpace("MAPI")

    # call the save method yo dave the email in the drafts folder
    $mail = $outlookObject.CreateItem(0)
    $null = $Mail.Recipients.Add("myBoss@company.com")  
    $null = $Mail.Recipients.Add("myBoss2@company.com")  
    $Mail.Subject = $email_Subject 

    $Mail.HTMLBody = "$htmlFile_AsString"
    # $mail.Attachments.Add($Source);
    $Mail.importance = 2 
    $Mail.save()

}
compose-OutlookEmail 

this error

The script failed due to call depth overflow.
    + CategoryInfo          : InvalidOperation: (0:Int32) [], ParentContainsErrorRecordException
    + FullyQualifiedErrorId : CallDepthOverflow

[PrzemyslawKlys]

No errors really.

[javadbacker]

I too didn't get error upon running the code by blocks for the small test script.
However, for the big script, I'm still getting the error. Trying to figure out what's causing.

I saw something similar in the link below.
seanmcne/Microsoft.Xrm.Data.PowerShell#276

https://weblogs.asp.net/jongalloway/working-around-a-powershell-call-depth-disaster-with-trampolines