Send email powershell accdb - Send Email with PowerShell in Microsoft Access


	Back to Send Email with PowerShell Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Send email powershell accdb

John Haubjerg

8 months ago

Hi
I'm trying to use this for sending email from my DB and it works fine withe the data from the form.
Is it possible to use data from a query instead. I have a query with max 4 rows.
Emailadress in each row. with soma data that belong to that email.
Can I loop through the query and send to all.

I hope I explained it OK

Thanks in advance

	Alex Hedley @Reply 8 months ago
Recordsets

	John Haubjerg OP @Reply 8 months ago
Thanks for your answer. I'm already doing this, but I want to use powershell, because no outlook on the computer that runs the accessDB That's why I want to use "Sendemailpowershell.accdb" It works fine from the form in that DB, But I want it to run auto. I really don't know what to do.

	Alex Hedley @Reply 8 months ago
What does your current code look like?

	John Haubjerg OP @Reply 8 months ago
It is here in the codevault. Data is taken from a form in the DB https://599cd.com/blog/display-article.asp?ID=3330

	Alex Hedley @Reply 8 months ago
Turn it into a function and pass in the things that change i.e. email address etc

	Alex Hedley @Reply 8 months ago
Create Function

	John Haubjerg OP @Reply 8 months ago
Alex Thanks. I will try to figure out how to do that :-)

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Send Email with PowerShell.

Next Unseen

New Feature: Comment Live View