1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Exporting QuickBooks Data

Discussion in 'General Business' started by ViciousSummer, Aug 5, 2005.

0
  1. #1
    I've been poking around Quickbooks, but I can't seem to figure this one out:

    I need to export my customers email addresses, which I have listed under the "Alt Contact" field. Is there a way to pull QuickBooks info from one field? :confused:
     
    ViciousSummer, Aug 5, 2005 IP
  2. tflight

    tflight Peon

    Messages:
    617
    Likes Received:
    38
    Best Answers:
    0
    Trophy Points:
    0
    #2
    What version of QuickBooks are you running? Pro, Enterprise, etc? Windows or Mac?

    When I export addresses the alt field is included without doing anything special. I don't think there is a built in function that will export just the alt field, but you can parse out the rest after the export.
     
    tflight, Aug 5, 2005 IP
    ViciousSummer likes this.
  3. ViciousSummer

    ViciousSummer Ayn Rand for President! Staff

    Messages:
    3,210
    Likes Received:
    526
    Best Answers:
    0
    Trophy Points:
    308
    #3
    I'm running QuickBooks Pro Mac.

    I saw that the alt field was included when I exported the customer info, but I was hoping there was an easier way :).

    In my perfect world, I could export any one field into an excel document...
    :D
     
    ViciousSummer, Aug 5, 2005 IP
  4. debunked

    debunked Prominent Member

    Messages:
    7,298
    Likes Received:
    416
    Best Answers:
    0
    Trophy Points:
    310
    #4
    get your brother to hack it, or to parse the export.
    I bet he can't do it. Ha-ha...
     
    debunked, Aug 5, 2005 IP
  5. tflight

    tflight Peon

    Messages:
    617
    Likes Received:
    38
    Best Answers:
    0
    Trophy Points:
    0
    #5
    I do hear that the next version of QuickBooks Pro for Mac might support integration/sync with Apple's built in Address Book.app. That would be a welcome feature. :)
     
    tflight, Aug 5, 2005 IP
  6. lorien1973

    lorien1973 Notable Member

    Messages:
    12,206
    Likes Received:
    601
    Best Answers:
    0
    Trophy Points:
    260
    #6
    If you wanna do something custom in quickbooks, the only thing to do is sigh sadly and accept the grim reality that is quickbooks. I think your best bet is to print the customer database to a file (instead of to a printer) and import into excel or something, then get the field you want.
     
    lorien1973, Aug 5, 2005 IP
    ViciousSummer likes this.
  7. ViciousSummer

    ViciousSummer Ayn Rand for President! Staff

    Messages:
    3,210
    Likes Received:
    526
    Best Answers:
    0
    Trophy Points:
    308
    #7
    Haha...I make him do way to much stuff for me already...:rolleyes:
     
    ViciousSummer, Aug 6, 2005 IP
  8. ViciousSummer

    ViciousSummer Ayn Rand for President! Staff

    Messages:
    3,210
    Likes Received:
    526
    Best Answers:
    0
    Trophy Points:
    308
    #8
    It really doesn't make much sense to me that Quickbooks can't perform simple tasks like this. Wouldn't it be common sense that you would want a collection of your customers email addresses? (Apparently not, since there isn't even a field for email addresses...haha) :rolleyes:
     
    ViciousSummer, Aug 6, 2005 IP
  9. debunked

    debunked Prominent Member

    Messages:
    7,298
    Likes Received:
    416
    Best Answers:
    0
    Trophy Points:
    310
    #9
    quickbooks was originally designed for just book keeping. THen everyone started to try using to run businesses. I was always frustrated with the limited abilities it had, now they have really made some hug changes.
     
    debunked, Aug 6, 2005 IP
  10. tflight

    tflight Peon

    Messages:
    617
    Likes Received:
    38
    Best Answers:
    0
    Trophy Points:
    0
    #10
    More often than not I can relate with vendors as to why you might want to leave "x" feature out... however in this case I agree with you. When I'm looking at an estimate or invoice for a client and I click the little email button the last thing I should have to do is fill out the email address. The Windows version of QuickBooks handles this better than the Mac version.
     
    tflight, Aug 6, 2005 IP
  11. yantomulia

    yantomulia Peon

    Messages:
    57
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #11
    have you solve that problems?
     
    yantomulia, Aug 20, 2008 IP