Find Jobs
Hire Freelancers

Generate email directly through SQL Server.

€30-250 EUR

Completed
Posted over 4 years ago

€30-250 EUR

Paid on delivery
I am collecting active directory users and save them in a SQL database to generate reports based on their location and group membership. I am looking for a solution which can find the users from database through SQL query and then find their email address from exchange server and generate an email based on a email template.
Project ID: 21324191

About the project

25 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hello Do you want a web application or desktop application? I can provide this solution in both platforms. Development technology wil be C# .Net. I hope that email template mapping with emails is also stored in sql database. Brief About Me: I am a "Full-Time" Individual freelancer having 10.5+ years of expertise over MS Technologies(C#). Apart from having relevant technical skills, I have good analytic skills and strong grasping power. I have 4~ years of experience of working as a full time freelancer and in that span I have worked over various Windows & Web Project ranging over various domains in different sub technologies. Please have a look over my profile to gain trust on me and my work
€250 EUR in 5 days
5.0 (17 reviews)
6.4
6.4
25 freelancers are bidding on average €152 EUR for this job
User Avatar
hey I'm Romain, a French Microsoft certified guy I can help you with that, I already wrote a lot of powershell scripts (you can have a look to my reviews) please contact me for more informations best regards, Romain
€100 EUR in 1 day
5.0 (35 reviews)
5.8
5.8
User Avatar
Hello! I am a Computer Engineer, with a Master of Business Administration and an MCSA SQL Server 2014, with 12 years of experience using SQL Server and multiple solutions around it. I am a near-native English speaker, currently available, and results-oriented. I can create what you require using only T-SQL code, which we can integrate later on a procedure or a trigger, as I have done it previously. We can discuss details over chat if you like. Thanks!
€150 EUR in 3 days
4.9 (20 reviews)
4.9
4.9
User Avatar
Hi, I am expert in sql server and I can do this job very well. Let me know if you want to find user and emails from exchange server and within in sql server . OR you have user table there in sql server. Thanks
€250 EUR in 7 days
5.0 (6 reviews)
4.6
4.6
User Avatar
Respected Sir, Greetings of the Day ! I am Subham Das. I have 9+ years of competitive experience in web application development using .net and SQL server. I have 7+ years of experience in Database development & management and i am expert in writing complex queries, stored procedure, User Defined Functions. My Skills ------------------- 1. Extensive Experience in writing complex queries 2. Expert in Writing Stored Procedures, Triggers, User Defined Fucntions 3. Expert in Creating and managing Jobs 4. Expert in SSRS If I can provide you with any further information on our background and qualifications ,Please let me know. I look forward to hearing from you , Thank you for your consideration. Regards Subham Das
€200 EUR in 10 days
5.0 (2 reviews)
4.3
4.3
User Avatar
Hi, My Name is Ali and I can work on it with immediate availability. What Edition of SQL Server you are using? I shall use DatabaseMail tool of SQL Server to send emails as per template. Let's have quick discussion so I can work on it.
€100 EUR in 7 days
5.0 (18 reviews)
4.5
4.5
User Avatar
Hi i am expertise to prepaere email remplates through sql server ee have to set server for email and will do
€111 EUR in 2 days
4.9 (14 reviews)
4.3
4.3
User Avatar
Hello, I have gone through the project detail, I am having required skills as described by you in the requirements. I am ready to start on this project. We can discuss further in private message. Thanks.
€185 EUR in 7 days
3.9 (8 reviews)
4.9
4.9
User Avatar
Hi Client , My name is Krish. I’m a Senior Software Developer & Freelance Web & Automation developer with 4+ years of experiences with Master degree holder and expertise in PYTHON, PHP, HTML 5, CSS3, JAVASCRIPT, NODE. JS, MYSQL, MONGODB, POWERSHELL technology with complete Full stack web developer and automation scripting developer Your organization's data cannot be pasted here. I’m a huge fan of the work, my goal is to get the project done on time with client satisfaction. If you have the time, I’d like to chat with you about the job requirements of yours. If you have time to talk, you can reach me anytime Thanks for your time, and I look forward to hearing from you. Best, Krish
€34 EUR in 2 days
5.0 (6 reviews)
3.3
3.3
User Avatar
After thoroughly going through your requirements I'm very confident that I can help you. This work is pretty straight forward and I already have a plan on how to do it therefore I can get it done right away and fairly quickly. We can further discuss privately and if you are satisfied with my approach we can move on with the project. Looking forward to hearing from you
€140 EUR in 7 days
5.0 (1 review)
2.7
2.7
User Avatar
Hi, I have 7+ years of experience working with top IT companies as a Database Developer specialized in Oracle, MySql and Sql server. I have read your project requirements and I am sure that I can develop a code to all the things mentioned. I assure highest quality code delivered.
€111 EUR in 3 days
5.0 (1 review)
2.1
2.1
User Avatar
Thanks for spending your valuable time for reading my proposal It may be something different if you feel something cool. Thanks TGG:) may be something different if you feel something cool. Thanks TGG:)
€140 EUR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear client! I read your project details carefully. I am very interested in your project because I have vast experieces like that before. I am very confident in your project.. As a senior full stack developer, I can fulfill your task perfect. Please feel free to contact me at anytime. Best regards . . . Roman.
€140 EUR in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi. hope you are doing well. As an web expert, I am very glad to see your project. Please check my profile here. https://www.freelancer.com/u/jabldamian26?w=f I have experience in development of the similiar projects. If you hire me, I'll do my best for your project and finish greatly in a short time. I'm sure I can satisfy for you as you want. Best regards Damian
€140 EUR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I am keen to work for those who need an expert in SQL Language and Database System. More than 7 years experience in many project on SQL, non-SQL, and Database Management such as MS SQL, Oracle, mySQL, Postgresql, MS Access, MongoDB, Firebase and so on. I developed many application , Script ,Telegram Bot, API, web scraping and data manipulation using Python. and Developed web applications using Angular, Bootstrap, Angular Material, Prime NG, Ant Design, and Express NodeJS. 3 years experience Data science , Data mining project using Python, Pandas, Numpy, R, Scikit learn, XGboost and Lightgbm. I have top 11% on Kaggle competitions See my Kaggle profile : @l0ginx or "Pratya Thanwatthanakit". I like to face technical challenges and feel pleasure to resolve. Please send me message so that we could discuss it further. To make sure that employment will truly serve your requirement, you can evaluate my skill by giving part of your coding for skill testing before hiring.
€200 EUR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I can create desktop software to you. You can see all of active directory users with all information. Then you can define text for dynamic ready e-mail template with .html extension by user group. I provide a button to you for sending e-mail. That's it. Note: I need to access your active directory account. I can also take current users as scheduled task every x miniutes/hours/days and then update the database. What do you say? Please review my profile. Thank you
€200 EUR in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
If you already have a database of AD users. A T-SQL query using a CLR or xp_cmdshell can be used to accomplish what you are looking for. For this to work, your SQL server has to have email already setup and either a) be running under a user name which has permission to query AD or b) you will need to create an xp_cmdshell proxy with the credentials that has access to AD. You will also need to have the Microsoft AD objects installed on the SQL server to reference the libraries from power shell. If you have all of this in place to make what you need is trivial, should require of no less than 1 hour.
€250 EUR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
sir , I'm a professional .Net developer with a great MSSQL experience , actually I've tow methods to achieve your request thatI've done before, one of them to send direct Database emails using a SQL account , or to use external desktop application to send these emails using SMTP by reading both AD mail list and the other data from the SQL DB ( that what i recommend ) , I've been through both projects and it was done properly , lets talk about details to finalize the offer
€200 EUR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I have plenty of experience using MS SQL Server, I've working with this Database System since 201. I'm also certified on MS SQL 2016. Regarding your project, it will be a task that will require to combine development and administration knowledge, I can achieve your project by creating some loops that will be automatically executed on the basis you specify. I hope I can work on your project. Best Regards!
€140 EUR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi After seeing your requirement, I found myself best suited for your project. I have 8 years of rich experience in MS SQL Server. Will be able to write query to fetch the record from database and then send email in a defined template. My technical skills are as follows SQL - DB Designing and Development, Table creation, constraints, DDL, DCL,DML statements, complex querying, stored procedures, views, cursors, functions, triggers, db backup and restore, auto backup full and differential, sql job agent, DB Mail Configuration, indexing, rebuild indexing, query optimization, performance check, activity monitor, sql profiler, linked servers, maintenance plan etc I’ll be able to complete the project in a given time. Waiting for a positive response. Regards Komal
€222 EUR in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have more than 7 years of experience as SQL SERVER Developer. The send mail task we use in our regularly processes. So I can understand your problem and resolve very easily. Even after I complete your task can give support some time. I hope will get this work from me.
€125 EUR in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of GERMANY
Hamburg, Germany
4.8
6
Payment method verified
Member since May 4, 2017

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.