auto email

[Admiral Huddy]

Can anyone think of a windows solution to look for a file with a specific name (.cvsv) that arrives in a designated folder, then sends that to a recipient by email?

Thanks

 

[hood1971]

One application I have been trying for other automation tasks is Robointern.

 

[Hades]

I'd probably be writing a python script to do it. But that would rely on having access to an SMTP server for sending emails.

 

[chroniclard]

Easy enough to write a c# console app to do it.

 

[Robi_uk]

As mentioned most scripting languages could be used to create you own one.
See here for some additional info: https://www.msoutlook.info/question/236

 

[touch]

a specific name (.cvsv)

Is that a typo for .csv or actually some real filetype you're using? Most email servers will reject email with non-standard file type attachments.

 

[planty]

If you're not able to write code yourself, try looking at RPA tools. Microsoft's Power Automate might do the job for you.

 

[ZombieFan]

Autohotkey can do this - but you'll probably have to write the script yourself.

 

[Admiral Huddy]

Easy enough to write a c# console app to do it.

If you know c#

Is that a typo for .csv or actually some real filetype you're using? Most email servers will reject email with non-standard file type attachments.

yes, it was sorry. The csv is being dropped into a share from an external source and emailed internally. As the file can come in at any time, the email means the user doesn't have to keep checking.

One application I have been trying for other automation tasks is Robointern.

This works a treat - Just needed a small script. Was up and running within a half hour.

 

[chroniclard]

If you know c#

True. Well what do you know?

*edit, resolved.

 

[Admiral Huddy]

Is that a typo for .csv or actually some real filetype you're using? Most email servers will reject email with non-standard file type attachments.

True. Well what do you know?

*edit, resolved.

I'm an old school IBM midrange programmer.. If i told you precisely, you'd think you'd have entered the Twilight Zone - believe me.

 

[chroniclard]

heh

 

[SoundsGood]

I'd use a PowerShell script running on a regular scheduled task
https://docs.microsoft.com/en-us/po....utility/send-mailmessage?view=powershell-7.1

 

[andyinv]

Another thumbs up for Powershell - either set up a FileSystemWatcher on the folder in question, or just do a DIR, sorted by lastwritetime, and use Send-MailMessage if required.

You might find SendGrid useful as well if you've no handy SMTP server.

 

[Hades]

I'm an old school IBM midrange programmer.

Old school IBM 3090 programmer waves \o/

 

[Admiral Huddy]

\o/ RPG developer.. I'm being moved to the Science museum next week.