Results 1 to 2 of 2

Email Listing Withheld Payment Information sourced from External Book

Threaded View

VBANood123 Email Listing Withheld... 06-22-2020, 10:40 PM
dangelor Re: Email Listing Withheld... 06-22-2020, 11:54 PM
  1. #1
    Registered User
    Join Date
    06-22-2020
    Location
    Alaska
    MS-Off Ver
    2016
    Posts
    4

    Question Email Listing Withheld Payment Information sourced from External Book

    (Intro):
    I send invoices to a company to get compensated for work. These invoices contain 6 pieces of information. They can each come in multiple forms and are all uniquely wrongful in someway and need attention. I have working code to fetch one array of all six pieces of information separately( as in piece one, piece two, piece three, rather than (piece one ... piece six) ). However, there are potentially an indefinite number of rows of this information and I only have code to account for one row.

    Here's my code to get all the information I need

    Dim CellValue As String
    Dim CellValueX As String
    Dim CellValueY As String
    Dim Value As String
    Dim Result As String
    Dim ErrorRange As String
    Dim ErrorCells As String
    Dim DateValue As Date
    
    
    CellValueY = Range("B2").Value
    'First Name
        
    CellValueX = Range("A2").Value
    'Last Name
        
        'P1
        'SHEET NAME
        
        CellValue1 = Range("I2")
        'Problem
            CellValue2 = Range("J2")
            'CC Paid?
                CellValue3 = Range("K2")
                'Billable?
                    CellValue4 = Range("L2")
                    'Billable Status
                        CellValue5 = Range("M2")
                        'Service Type
                            CellValue6 = Range("N2")
                            'F2F Date 1
                                CellValue7 = Range("O2")
                                'CONT Date 2
    End Sub
    (Problem)
    This array of information goes into one row on an Email. I have that part working fine, I just need help getting more than one array.

    TL;DR - Problem
    I'm sending invoices back for another go over and I can't get more than one invoice at a time to come back. I need multiple cells/ranges of information at a time but I can only get one. Help!

    Any guidance is deeply appreciated.
    Last edited by VBANood123; 06-29-2020 at 01:56 PM. Reason: Narrow down the problem

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 05-11-2020, 02:36 AM
  2. [SOLVED] Inserting rows when Book ISBNs listing switches to DVD EANs
    By Chriz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-24-2013, 01:53 AM
  3. Fees Payment Record and listing
    By Uma Shankar Mishra in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-17-2012, 07:10 AM
  4. Bank loan payment book - Need Help Please
    By wtp in forum Excel General
    Replies: 0
    Last Post: 07-19-2012, 07:27 PM
  5. Combo Box listing external filenames
    By SydnTex in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-05-2006, 10:48 AM
  6. [SOLVED] Transfer Email addresses from spreadsheet to email address book
    By Beana in forum Excel General
    Replies: 2
    Last Post: 05-30-2006, 01:10 PM
  7. How to do a macro for Payment Voucher, Cash Book, and Bank Checks/Cheques?
    By Susan Soo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-23-2005, 10:11 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1