Skip to main content
InvoicingTemplate.com main content

Invoicing Template to Emailc3017

Invoicing Sample to Email

"Invoicing Template to Email" was found to be relative to Email Invoice with the score grade of 92.

...(18) If the template you choose already has the email address inside the printable invoice form, skip this step.

  1. Backup the template that you want to customize / edit.
  2. Open it.
  3. Click the "Design Mode" button on the "Invoice" ribbon tab.
  4. Click to select the "Country" label object in the "Bill To" section. Hit DEL key on keyboard to delete it.
  5. Go to Excel "Formula" tab and click "Name Manager".
  6. On the name list click the column heading "Name" to sort list by name. Find and select the name "oknCountry", and then click "Delete".
  7. Click "Close" to close the "Name Manager" dialog box.
  8. Click and select the cell where the original country field resides, i.e. $I13:K13 (This is a merged cell range).
  9. Enter the new name "oknWhoEmail" on the name box of the formula bar. By naming this cell "oknWhoEmail", the content of this cell is mapped to (or linked to) the customer's email field in the backend database. For a complete list of name mapping rules, refer to Uniform Invoice Software help documents.
  10. You may also like to add a label for this field. To do this, right-click the "City, State ZIP" label, and choose "Copy" from the shortcut menu.
  11. Right-Click cell $G$13 and choose "Paste" from the shortcut menu.
  12. Right-click the newly created label and choose "Properties".
  13. In the "Caption" field enter the label text "Email".
  14. Close the "Properties" window.
  15. You can move the proper location by dragging and dropping.
  16. One done, click the "Design Mode" button again on the "Invoice" ribbon tab to exit design mode.
  17. Save the template by clicking the "Save" button on Excel quick access toolbar.

Basic Sales Invoice with Blue-violet Gradient Backgroundc3018

Basic Billing Format with Blue-violet Gradient Background

"Basic Sales Invoice with Blue-violet Gradient Background" was found to be relative to Email Invoice with the score grade of 91.

...(34) This basic sales invoicing sample has an abstract blue-violet gradient painting in the background that looks like brushed with a liquid. This design sample also has the stripes background on the detail section removed.

...(30) So when you fill in an invoiced item with the "amount" (field name "oknLinetotal_?") value, the "#" column is filled with a line # like "1, 2, 3 ..." etc.

...(38) The "Amount" column on this field is manually editable on creating invoices. This is archived by removing all the formulas from the column, and then unlock the cells so that they are editable when the template is protected.

Invoicing Template with Watermark of New Yorkc4101

Invoicing Format with Watermark of New York

"Invoicing Template with Watermark of New York" was found to be relative to Email Invoice with the score grade of 89.

...(99) As detailed in the "Create Invoice Template" document, all shapes including images must have its name prefixed "oknWidget" in order to be retained on the extracted version (which is still an Excel workbook file, but contains only the invoice sheet), and the PDF invoice created with UIS. This sample follow that guidelines, so that the widgets, such as the boxes for the "BILL TO" and "SHIP TO" sections, are kept on the result invoices. On the other hand, buttons like "Save As New Customer", "View Customer Info." and "Same As Bill To" are all removed from the PDF invoices.

Blank Service Invoice Template with Image Borderc3019

Blank Service Bill Format with Image Border

"Blank Service Invoice Template with Image Border" was found to be relative to Email Invoice with the score grade of 89.

...(43) This blank service invoice template is a redesigned version of c3008 Blank Service Invoicing Template. This customized version keeps most of the fields found in the original design, but have a complete new look and feel due the addition of the image borders.

...(41) We also narrow down the form. To do this, we moved out the "Ship Date" and "Ship Via" fields (i.e. the "oknShipDate" and the "oknShipVia" cells and their labels), which are likely not useful since it is a service invoice template.

Advanced Invoicing Sample - Email Is Required Before Saving Invoicec5103

Advanced Invoicing Format - Email Is Required Before Saving Invoice

"Advanced Invoicing Sample - Email Is Required Before Saving Invoice" was found to be relative to Email Invoice with the score grade of 69.

  1. First open your invoice template as usual.
  2. Press ALT+F11 on keyboard to open the macro editor (Visual Basic for Applications editor).
  3. Add a reference to "UniformInvoiceSoftwareHelper": click the menu "Tools" / "Reference"; on the "References - VBA Project" dialog box check "UniformInvoiceSoftwareHelper" and then click "OK".
  4. Create a new module by clicking the menu "Insert", and then "Module".
  5. Copy & paste the following code into the editor.
    
    Option Explicit
    Public Sub NewSaveToDBProc()
        
        If Range("oknWhoEmail").Value = "" Then
            MsgBox "Please enter email address in the 'Bill To' section.", vbExclamation + vbOKOnly, "Save Invoice"
            Exit Sub
        End If
        
        UISClickProc ("oknCmdSave")
        
         
    End Sub
    
  6. Click menu "File" and then "Save".
  7. Click menu "File" and then "Close and Return to Microsoft Excel".
  8. Click the "Design Mode" button on the "Invoice" worksheet.
  9. Right-click the "Save To DB" button, choose "Assign Macro..." from the shortcut menu.
  10. On the "Assign Macro" dialog box, click and choose "NewSaveToDBProc" (which is the procedure name we created in the previous steps).
  11. Click "OK" to assign this new macro to the button and close the "Assign Macro" dialog box.
  12. Exit design mode by clicking the "Design Mode" button again on the "Invoice" worksheet.
  13. Save the template by clicking the "Save" button on Excel quick access toolbar.

Bill Format for Dental Clinic and Denture Laboratoryc5097

Receipt Sample for Dental Clinic and Denture Laboratory

"Bill Format for Dental Clinic and Denture Laboratory" was found to be relative to Email Invoice with the score grade of 67.

...(120) This dental receipt sample also features two images in additional to the logo image located on the top-left. The first image is visible when you are filling an invoice - a tooth carton image on left-bottom, which is inserted into this dentist receipt format sample as a shape object. The second image is not visible when you are creating invoices using the form, but will show on top-right on the bills, which features a doctor / dentist and along with a dental chair. This second image is added as a background image. It shows only on printed bills and receipts, or PDF dental invoices created by using Uniform Invoice Software. See invoice template images for more samples on this topic.

Bill Format for Painting Servicec4087

Invoicing Template for Painting Service

"Invoicing Template for Painting Service" was found to be relative to Email Invoice with the score grade of 66.

...(46) For businesses or contractors who provide painting service or work as a house painter, download this free invoice template to create professional bills and invoices as easy as filling in a blank paper forms. You can print hard copy, or email the PDF painting invoice electronically.

...(37) Like they said, a picture is worth a thousand words. This is true even to an invoicing form such as this one designed for painters. The images easily make the form not only professional, but also elegant.

Business Invoice with Customer-Specific Discountingc5108

Business Invoice Template with Customer-Specific Discounting

"Business Invoice with Customer-Specific Discounting" was found to be relative to Email Invoice with the score grade of 62.

...(46) With this business invoice template you can assign each customer a specific discounting rate. This rate is saved with other customer information such as street address and email. On creating invoices if you choose a customer, its discount level / rate is retrieved and applied too.

...(52) No matter what business you are in, returning customers are always valuable. To encourage those customers and express your gratitude, a discount shown on invoice is a great way to do that. This business invoice template implements that by using a custom field created in both the "Customer" and "InvHdr" database tables.

Freelance Writer Invoicec3012

Freelance Writer Invoice

"Freelance Writer Invoice" was found to be relative to Email Invoice with the score grade of 61.

...(88) (Note that if you have installed the latest version of our invoicing software, Uniform Invoice Software, which is able to upgrade a simple template in Microsoft Excel spreadsheet format into a complete invoicing system, you don't have to replace the logo image manually - you can replace the default logo image by clicking the "Replace Logo Image" button on the ribbon tab in Excel 2007, Excel 2010 and Excel 2013). To replace the default LOGO image in Freelance Writer Invoice with your own image, follow the steps below:

Attorney Invoice Template (South Africa Currency)c5067

Attorney Invoice Template (South Africa Currency)

"Attorney Billing Statement (South Africa Currency)" was found to be relative to Email Invoice with the score grade of 57.

...(113) An invoice is a form of communication with a client. The contents of an invoice should be prepared with the same thought and effort as a letter to be sent to a client. The invoicing templates provided to you by InvoicingTemplate.com allows you to do this in a professional and easy way. If you use Uniform Invoice Software, which turns an simple Excel template into a complete invoicing creator or billing system, the invoicing functionality offers a series of settings and options that enable small law firms to efficiently create customized professional invoices that can include personalized messages and client payment history, plus the ability to email directly from within the invoicing application.

...(79) The support for custom fields makes it possible for even an end user who does not know programming at all, could add new features to her/his invoicing creator such as Attorney Invoice Template (South Africa Currency) without writing one line of programming code. Feel free to Search and download more samples. Sometimes our customization samples are offered in two editions here on InvoicingTemplate.com, that are one freeware edition, and another edition that works only with our invoicing software installed.

Bill Format for Computer Repair Servicec5096

Invoicing Template for Computer Repair Service

"Invoicing Template for Computer Repair Service " was found to be relative to Email Invoice with the score grade of 56.

...(92) On the heading section, there are spaces for a logo image, your computer repair business information, a big text title "INVOICE" indicating the type of this document, and also the two most important fields for any invoice - the invoice# and invoice date cells. If you have Uniform Invoice Software installed, our invoicing software app is able to generate increment and unique invoice numbers based on a counter inside database. This "auto numbering" feature is a huge time-saving functionality as you don't have to manually create and track used invoice numbers again.

Basic Blank Service Billing Format (No-tax, Long Description)c2015

Basic Blank Service Billing Layout (No-tax, Long Description)

"Basic Blank Service Billing Layout (No-tax, Long Description)" was found to be relative to Email Invoice with the score grade of 47.

...(107) A blank PDF invoice template is also available for Basic Blank Service Billing Format (No-tax, Long Description), which you can download free of charge from InvoicingTemplate.com. It is generated by using the "export to PDF format" feature that is built in with Microsoft Excel. If Uniform Invoice Software is installed on your computer, this template, "Basic Blank Service Billing Format (No-tax, Long Description)" or "Basic Blank Service Billing Layout (No-tax, Long Description)", the "Extract/Email" command could also generate PDF invoice for you, or send electronic invoice in PDF (or Excel spreadsheet format, or image/PNG format) with email. This could be done by a simple clicking of mouse!

One Tax Column, No Shipping Addressc5002

One Tax Column, No Shipping Address

"One Tax Column, No Shipping Address" was found to be relative to Email Invoice with the score grade of 45.

...(18) This "One Tax Column, No Shipping Address" invoice template is a variant of Invoice Template with Tax Column.

General Service Invoicec5012

General Service Bill

"General Service Invoice" was found to be relative to Email Invoice with the score grade of 35.

...(43) This general service invoice template / bill form features a logo image, invoice# and date on top of the form. Next to it is the "Bill To" section. This Excel billing format features 5 columns - Date, Description, Quantity, Unit Price and Amount.

...(34) As a service invoice template, this form does not contain the shipping address section, just like other generic service invoice samples here on InvoicingTemplate.com. For more samples on general invoices, visit General Invoice Templates.

...(35) This template was originally published on office-kit.com as C5-012. The description of this template on office-kit.com is attached below. Note that we've made modifications to the form during upgrading it for publishing here on InvoicingTemplate.com.

Australian GST Invoice Templatec7018

Australian GST Billing Form

"Australian GST Invoice Template" was found to be relative to Email Invoice with the score grade of 28.

...(105) Although it is easy to create the layout and format of Australian GST Invoice Template with Microsoft Word or other Microsoft Office programs, or even with some PDF programs like Adobe Acrobat, the support for Excel formulas makes doing automated calculations easy to implement and modify. For example, Australian GST Invoice Template uses Excel formulas extensively to do calculations whenever possible and necessary, such as the taxes, totals. If you use the Uniform Invoice Software version of Australian GST Invoice Template, Excel formulas are also used to create the relationship between several fields, such as one field should be the sum of two other fields.

Transportation Invoicec5014

Transportation Bill Format

"Transportation Invoice" was found to be relative to Email Invoice with the score grade of 27.

...(93) The benefits of Excel transportation billing template, instead of using Microsoft Word (usually ".doc" or ".docx") format, is that you are not only able to format the document in the way you like, but also able to do calculations easily. If you install Uniform Invoice Software, the simple transportation invoice template becomes powerful transportation invoice software, allowing to easily manage clients, products, invoices, and fee, payments and account receivables easily. For example, you are no longer need to manage invoice numbers manually. See automatic invoice numbering to find out how to do that.

...(66) Five columns included in this invoice template are Date, Product code (Product ID in the original invoice template), Passenger, Description, Fare. Since this is a service invoice template, the Quantity column in the original default invoice template is moved out of the Print_Area, with a default value of 1. For information on how to move cells, please see Creating and Customizing Invoice Template - Moving Cells/Controls.

Labor Invoice with Gradient Borderc4076

Labor Invoice with Gradient Border

"Labor Service Invoice with Gradient Border" was found to be relative to Email Invoice with the score grade of 18.

...(34) This labor invoice calculates amount from hours and hourly rate, just like its base template. It differs from the base template in that we added a gradient border to surround the entire printable form.

...(57) Assuming the printable form has 10 rows and we choose to fill the left-border column with gradient colors, each of the 10 cells on the left-border column will be filled with a separate gradient effect. This isn't what we want because we want the whole left-border, from top to bottom, be filled with only one gradient effect.

Lightweight Sales Invoice Templatec5070

Lightweight Sales Invoice Template

"Lightweight Sales Billing Form" was found to be relative to Email Invoice with the score grade of 17.

...(29) The lightweight Sales Invoice Template does not include a default logo image, and the column borders on the invoice detail section are also removed to simplify the invoice layout.

...(70) This template, Lightweight Sales Billing Form, does not uses custom fields, although you can easily add them with Uniform Invoice Software. With Excel Invoice Manager, which is our first generation of invoicing software based on Microsoft Excel, where custom fields (i.e. user-defined fields) should be defined using a standalone tool, Uniform Invoice Software integrates the "Custom Field Manager" into the main program itself and simplifies the use of custom field.

Invoice and Packing List on Same Formc4078

Invoice and Packing List on Same Form

"Invoice and Packing Slip on Same Form" was found to be relative to Email Invoice with the score grade of 6.

...(49) A shipping packing list is also called delivery docket, it shows what goods included on shipment, also serve as a bill of lading. It is naturally close related to invoices. In this sample template we demonstrates how to create a packing list and an invoice within one same form.

...(57) To archive this goal, we first have to copy the existing invoice design to create a new form, and then modify the new form to make it suitable for packing lists. And finally, we modify the definition of the printable form, to have Excel print both documents (the invoice and the packing list) at the same time.

Specifications

Template#
Title
Release Date
Lines
Columns
Paper
Orientation
Category
c3017
Invoicing Template to Email
Thursday, August 21, 0206,
12
3
A4
Portrait
Sales
c3018
Basic Sales Invoice with Blue-violet Gradient Background
Sunday, October 30, 2016,
12
3
A4
Portrait
Sales
c4101
Invoicing Template with Watermark of New York
Wednesday, November 30, 2016,
6
4
A4
Portrait
Sales
c3019
Blank Service Invoice Template with Image Border
Monday, November 21, 2016,
8
3
A4
Portrait
Service
c5103
Advanced Invoicing Sample - Email Is Required Before Saving Invoice
Tuesday, November 22, 2016,
12
5
A4
Portrait
Sales
c5097
Bill Format for Dental Clinic and Denture Laboratory
Wednesday, October 19, 2016,
12
5
A4
Portrait
Receipt
c4087
Bill Format for Painting Service
Saturday, October 22, 2016,
8
4
Letter (8-1/2 in. x 11 in.)
Portrait
Service
c5108
Business Invoice with Customer-Specific Discounting
Saturday, March 25, 2017,
8
5
A4
Portrait
Sales
c3012
Freelance Writer Invoice
Saturday, May 14, 2016,
10
3
A4
Portrait
Service
c5067
Attorney Invoice Template (South Africa Currency)
Saturday, September 27, 2014,
12
5
A4
Portrait
Consulting
c5096
Bill Format for Computer Repair Service
Tuesday, October 18, 2016,
12
5
A4
Portrait
Service
c2015
Basic Blank Service Billing Format (No-tax, Long Description)
Wednesday, November 18, 2015,
5
2
A4
Portrait
Service
c5002
One Tax Column, No Shipping Address
Wednesday, November 6, 2013,
12
5
A4
Portrait
Service
c5012
General Service Invoice
Saturday, March 18, 2017,
12
5
A4
Portrait
Service
c7018
Australian GST Invoice Template
Saturday, March 1, 2014,
17
7
A4
Portrait
Sales
c5014
Transportation Invoice
Thursday, March 16, 2017,
16
5
A4
Portrait
Service
c5113
Drop-down List for Multiple Price Levels
Tuesday, April 4, 2017,
30
5
A4
Portrait
Sales
c4076
Labor Invoice with Gradient Border
Saturday, July 2, 2016,
8
4
A4
Portrait
Service
c5070
Lightweight Sales Invoice Template
Tuesday, July 21, 2015,
16
5
A4
Portrait
Sales
c4078
Invoice and Packing List on Same Form
Wednesday, July 6, 2016,
20
4
A4
Portrait
Sales

What Is Hot

Feature Galleries