Completato

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.

Competenze: Elaborazione dati, Excel, VB.NET, Visual Basic, Visual Basic per App

Vedere di più: 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

Sul datore di lavoro:
( 2 valutazioni ) Pasadena, United States

ID Progetto: #18135248

Assegnato a:

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 Più

$200 USD in 3 giorni
(35 valutazioni)
4.9

5 freelance hanno fatto un'offerta media di $226 per questo lavoro

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 Più

$350 USD in 2 giorni
(168 Recensioni)
6.3
periyannas

Ok Sure

$182 USD in 3 giorni
(65 Recensioni)
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 Più

$140 USD in 2 giorni
(15 Recensioni)
5.2
$258 USD in 2 giorni
(40 Recensioni)
5.2