已完成

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.

技能: 数据处理, Excel, VB.NET, Visual Basic, Visual Basic的应用程式

查看更多: 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

关于此雇主:
( 2个评论 ) Pasadena, United States

项目ID: #18135248

授予:

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 更多

$200 USD 在3天内
(35条评论)
4.9

5 威客就此工作平均出价 $226

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 更多

$350 USD 在2天内
(168条评论)
6.3
periyannas

Ok Sure

$182 USD 在3天内
(65条评论)
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 更多

$140 USD 在2天内
(15条评论)
5.2
$258 USD 在2天内
(40条评论)
5.2