Befejezett

Create Email messages using VBA within Excel, each email containing some info from the relevant rows for that email recipient

I need this done in 12-24 hours.

Purpose: The purpose of our “Exceptions Payroll Report” spreadsheet is to check “timecard-like” values that users entered into our EMR. We are looking for exceptions, such as “overlapping visits”, or “visit-time < 20 minutes”. There 12 exceptions defined (10 ERRs, 2 CHKs.)

---------------------------------------------------------------------------------------------------------------------------------------------

Your Task: The worksheet/tab that you need to look at it is “Errors”. The data is already sorted in the right order. All you have to do is this: Using VBA, create VBA code that will generate one HTML email message for each User(User#) showing their daily “time-card” and whatever ERRs or CHKs there are. There are 9 distinct “users(user#)” (column AE) and 111 rows. I am expecting 9 emails, each email having 1 or more HTML tables for that user (a separate HTML table for each distinct date.) To be clear, I (my company) will own this VBA code that you create. This is a “work for hire” project. See two attachments: The source data Excel file, and a Word document that explains the project in more detail.

Készségek: Adatfeldolgozás, Excel, VB.NET, Visual Basic, Visual Basic for Apps

Bővebben: data excel workbook master workbook using vba, mhtml part body email using vba, vba excel worksheet info form, excel vba send email without outlook, excel vba send email with attachment, macro to send email from excel using outlook, macro to send email from excel with body, vba send email outlook, excel vba create email but don't send, vba code to send email from excel to outlook, excel macro to send email automatically, microsoft outlook, microsoft excel, export data webpage excel sheet using vba, create thumbnails using vba, import dat file using vba excel, create lotto excel using vba, printdisplay using vba excel, create roster using vba excel, download file web using vba excel

A munkaadóról:
( 2 értékelés ) Pasadena, United States

Projektazonosító: #18135248

Odaítélve:

gr8tech

Hello I am available to generate the VBA code which will create appropriate HTML tables for inserting into an email as requested. According to your project description, the email could be done in Outlook. I have exper Több

$200 USD 3 napon belül
(35 értékelés)
4.9

5 szabadúszó tett átlagosan $226 árajánlatot erre a munkára

gangabass

I can provide you VBA code that will generate HTML emails in a format you want. It will read your Excel column AE and generate one email for each user (one table per each day). I can start today and complete it in Több

$350 USD 2 napon belül
(168 vélemény)
6.3
periyannas

Ok Sure

$182 USD 3 napon belül
(65 vélemény)
5.7
vaidyag

HI, I have excellent experience in C#, Excel and Access and other Microsoft related technologies. I have written complex macros like creating a BoM for an ERP, creating P/L, Cashflow statements from a database. I hav Több

$140 USD 2 napon belül
(15 vélemény)
5.2
$258 USD 2 napon belül
(40 vélemény)
5.2