Automatic Email Processing created from database data

Overview of project

Project to be inn VB6 classic (no need to be able to create connection to an external Pervasive database, and be familiar with creating emails with parameters.

1 –Enter processing date from a selection panel created in VB. We will provide the outlook for this in VB6 code

2 - Using SQL, program select data to create and send emails to various customers.

3– From the data retrieved the following info will be used to send SPECIFIC email to SPECIFIC customer.

1. For each sales ticket number, select ONLY the first line of data returned and skip the other lines

2. Select the following fields:

a. First name ()

b. Last name ()

c. Store Number()

d. Salesperson Number ()

e. Salesperson Name ()

f. Date purchase() – this date will need to be recreated as standard date ( from 20130428 to 04/28/2013 for example)

g. Department Number () – Department number is used to retrieve from external table () the type of email to send.

3. After selecting the type of email from the table (), pass the parameter to the email (First name, last Name, Salesperson Name, Date Purchase) to the email form and send email

4. Write to external log file the information regarding this email (Date Email Sent, Date Purchase, Ticket Number, Customer last name, Email Address)

5. From selection panel, user can start process that will send a discount coupon to people that already receive an email. Process will

Skills: Visual Basic

See more: automatic data processing, start an email, email g, need a salesperson, processing customer info, pervasive sql, inn, first name email, email process, creating emails, sql created, sql retrieve table, example sql vb6, send receive email vb6, enter coupon code, outlook retrieve, ticket line, write file vb6, line ticket, example code vb6 sql database, net send email, write sales email, retrieve email, sql automatic program, sales ticket

About the Employer:
( 61 reviews ) NY, United States

Project ID: #4728445

9 freelancers are bidding on average $247 for this job


Please check your PM.

$266 USD in 3 days
(15 Reviews)

More than 10+ years experience in VB6.0,Ready to start.

$200 USD in 7 days
(31 Reviews)

More than 15 years experience in computer programming and top 1% in VB6 on Freelancer.

$277 USD in 7 days
(10 Reviews)

I have experience in developing UI's in VB6 and in creating database-driven software. Please review my work history for examples of VB6 and .Net forms-based projects that I have completed. From my reading of your s More

$274 USD in 10 days
(7 Reviews)

100 % solution of Automatic Email Processing created from database data

$300 USD in 10 days
(1 Review)

Ready to take over. Kindly see PMB

$159 USD in 5 days
(8 Reviews)

Hi Sir, I'm ready. Kindly check your PMB. Thanks SKAP

$315 USD in 10 days
(2 Reviews)

Very strong Visual Basic Experience creating Parameterized Emails.

$277 USD in 10 days
(1 Review)

Hi, I am experience software engineer. Please read PM for details

$155 USD in 3 days
(0 Reviews)