Can Access email via Yahoo or PowerShell ?

[PNGBill]

Hi Forum, Access 2000 on XP sp3

We are emailing direct from Access and very pleased with.
Our Outlook Express screen pops up when Access wants to send an email.
Outlook Express holds our dns server info.

Have just got PowerShell to work so it tidies up some of our filing from the Access .pdf files saved with our Stephen Lebans code - great stuff.
PowerShell also forwards our incoming faxes by email - the code refers to our DNS Server.

Now the Problem...
We want to travel over Xmas and do work with our database on a notebook.

So can we use Yahoo for emailing from Access??
Yahoo of course is web based and we won't be taking our dns server with us.

Powershell is supposed to be able to send mail via Yahoo but can Access also do this??

It would need to hold our login name and password plus the smtp server name.

Or would it be easier to get an email address in New Zealand and use that?

Trust the post makes sence and appreciate any advice etc.

Regards,
bill

 

[HiTechCoach]

PowerShell also forwards our incoming faxes by email - the code refers to our DNS Server.

Now the Problem...
We want to travel over Xmas and do work with our database on a notebook.

So can we use Yahoo for emailing from Access??
Yahoo of course is web based and we won't be taking our dns server with us.

You do not have to use it only web based.

See: POP Yahoo! Mail with Microsoft Outlook Express

Why not just configure Outlook express to send using Yahoo?

Hi Forum, Access 2000 on XP sp3
Have just got PowerShell to work so it tidies up some of our filing from the Access .pdf files saved with our Stephen Lebans code - great stuff.

Really curious.

Why do you need Powershell "so it tidies up some of our filing"?

What does Powershell do for you that Access can't do?

 

[PNGBill]

Really curious.

Why do you need Powershell "so it tidies up some of our filing"?

What does Powershell do for you that Access can't do?

I guess this is because in my www search I was lead down the PowerShell path.
Thick VBA access 2000 handbook doesn't cover these sorts of issues.

Access creates .pdf files and Kills any created by a user they close their front end.
Where the .pdf is a Letter and needs to be Archived, it has X.pdf as the last 4 chrs in file name. These are not Killed.
PowerShell comes along every hour and moves these to an Archive folder and removes the X.
Powershell checks for the folder first and creates it if not present. Folder name includes today's date.

Here is my Script.

#PowerShell
#Script Name:        ArchiveLetters.ps1
#Created on:        2010-11-28
#Auther:        Bill McKinstry - Adapted from Kent Finkle post 2006-09-18
#Purpose:        Verify if Folder Exits and if not, Create Folder

#Populate an array with files that match - this will determine if there are any files to process
#ensure we are working in corect path
Set-Location -Path W:\Attachments
#create and populate array
[array]$strFileNames = @(Get-Childitem | Where-Object `
    {$_.name -like "*Reminder*.pdf" -or $_.name -like "*Warning*.pdf" -or $_.name -like "*Demand*.pdf"}) `
    | Select-Object name
#Count number of records in array
$FC = $strFileNames.count
#Check If Files Exist and if they do, Continue 
if ($Fc -gt 0)
    {
    Write-Host "There are " $FC " Files that need to be renamed and moved"
    #Variable to hold folder name and path for Today
    $FoldPath = Get-Date -Uformat "W:\AAReminderLetters\Letters%YYear\Letters%Y%m%d\"
    #If Statement to check if a Folder Exists for Today's Date and if not, create folder
    If ([IO.Directory]::Exists($FoldPath))
        {
        Write-Host "Folder " $FoldPath "Exists"
        }
        Else
        {
        Write-Host "Folder " $FoldPath " Does not exist and will be made now"
        New-Item -Path $FoldPath -type directory
        }
        #rename and move files
            $strFileNames | ForEach-Object { 
            Move-Item $_.name -Destination $FoldPath              
                Rename-Item ($FoldPath + $_.name) -newname $_.name.replace("X.pdf",".pdf")            
            }
    }               
Else    
    #No Files Exist - say so and exit        
    {    
    Write-Host "There are no Files to rename and move at this time"    
    }
    #Return to Home
    Set-Location C:\MyScripts
    exit

 

[PNGBill]

You do not have to use it only web based.

See: POP Yahoo! Mail with Microsoft Outlook Express

Why not just configure Outlook express to send using Yahoo?

Thanks HighTechCoach, never thought of that. Will check out now.

 

[PNGBill]

This link is for getting mail from Yahoo into the operators outlook client.

I need to go the other way.

I want to send mail from a pc via yahoo to a recipient but without using webmail.

This PowerShell Script will send an email from my pc to any recipient via Gmail

$smtpClient = new-object system.net.mail.smtpClient
$smtpClient.Host = 'smtp.gmail.com'
$smtpClient.Port = 587
$smtpClient.EnableSsl = $true
$smtpClient.Credentials = [Net.NetworkCredential](Get-Credential ClubGroupLimited)
$smtpClient.Send('Gmailaccountname@gmail.com','Fred.Smith@whereever.com','test subject', 'test message')

It needs more work to carry an attachment etc.


I will play with my Outlook express and see if I can get it working.

With Access, how does this command know where to find the smtp server??

DoCmd.SendObject , , acFormatTXT, varTo, , , stSubject, stText, -1

Does it use the pc's default setting??

Can we include in this command to use a specific smtp server and also have username and password included?

Thanks for the assistance.

 

[PNGBill]

Why not just configure Outlook express to send using Yahoo?

Thanks again HiTechCoach,
I just used the Yahoo smtp server name and port 465 in my outlook outgoing mail server settings and Wala, mail is going direct from ms access via www to yahoo and then off to the recipient.

This means my PowerShell tutorials may not have been needed but I have opened up a whole new "can of worms"

I guess inexperience has a cost. 2 weeks to do a 5 min job

Will I be "cautioned" for doing scripting??

 

[HiTechCoach]

Thanks again HiTechCoach,
I just used the Yahoo smtp server name and port 465 in my outlook outgoing mail server settings and Wala, mail is going direct from ms access via www to yahoo and then off to the recipient.

This means my PowerShell tutorials may not have been needed but I have opened up a whole new "can of worms"

I guess inexperience has a cost. 2 weeks to do a 5 min job

Glad to hear that you got working.

Will I be "cautioned" for doing scripting??

Not from me.

Kudos to you for learning PowerShell. I am sure that your PowerShell skills will come in handy.

You have inspired me to learn PowerShell.

Thank you for sharing your scripts.