Results 1 to 9 of 9
  1. #1
    Star Lounger
    Join Date
    Mar 2004
    Posts
    78
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Output TEXT BOX to Word (XP)

    Hello again

    I'm trying to output the contents of a Text Box to a new Word doc (just so that someone can send a one-off letter to the person selected).
    However, it seems that the code I'm using is designed to output an entire Table/Query to Word, whereas I would just like to send the contents of a Text Box to a new Word doc.
    I've tried using the following code:
    DoCmd.TransferText acExportDelim, , FullName, "C:New.doc", which doesn't work . . . I got an Error message. The funny thing was that the contents of the Text Box were IN the Error Code message!

    Am I using the wrong method, or have I left something out?

    Thanks in advance for your help.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Output TEXT BOX to Word (XP)

    TransferText exports an entire table or query to a text file, not the contents of a single text box to a Word document. For your purpose, Automation is probably the best option, but it is not a trivial subject. My fellow moderator <!profile=WendellB>WendellB<!/profile> has a short tutorial on Automation on his website, with many useful links. See Automation 101.

  3. #3
    Star Lounger
    Join Date
    Mar 2004
    Posts
    78
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Output TEXT BOX to Word (XP)

    Oh right. I'll PM Wendell to ask him how much it would cost to do this.

    Thanks Hans.

    <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  4. #4
    Star Lounger
    Join Date
    Mar 2004
    Posts
    78
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Output TEXT BOX to Word (XP)

    Hi Hans

    Following your post, I E-mailed Wendell, but I haven't heard back. I checked his website, but I can't find any alternate E-mail address (in case he's been too busy to check in at WOPR). Would you happen to know if he's on holiday or whether there's someone else that could work on this code for me (paid for, naturally)?

    Thanks in advance. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Output TEXT BOX to Word (XP)

    Have you tried the e-mail addresses in About Us?

  6. #6
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,613
    Thanks
    3
    Thanked 58 Times in 58 Posts

    Re: Output TEXT BOX to Word (XP)

    See my reply to your email - we've been swamped with moving and picking up a new client. Hopefully I'll be back in the Lounge on a more frequent basis shortly.
    Wendell

  7. #7
    Star Lounger
    Join Date
    Mar 2004
    Posts
    78
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Output TEXT BOX to Word (XP)

    Thanks Hans. I was on the Services or Products page when I clicked Contact, and the Menu expands to show Wendell Bio. I had clicked such but not WBA Inc, and that's why I didn't see the E-mail links.

    Wendell, thanks for your E-mail. I shall reply now.

    Thanks again to both of you.

  8. #8
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,613
    Thanks
    3
    Thanked 58 Times in 58 Posts

    Re: Output TEXT BOX to Word (XP)

    You email to me contained an attachment that my eMail provider thought looked like a virus. Let me suggest that you post the attachment as an attachment to a response to this message - see <!help=08>Help 08<!/help>. That way we avoid eMail virus checkers, and my own system can decide what to allow.
    Wendell

  9. #9
    Star Lounger
    Join Date
    Mar 2004
    Posts
    78
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Output TEXT BOX to Word (XP)

    Actually, it didn't contain an attachment. I know that there can be a problem with E-mail Servers being unable to recognize Rich Text Format (although I use HTML as my Outlook Format). Perhaps a Server couldn't parse the message and so stripped the text and put it in an attachment? I'll resend it Plain Text.

    Thanks

Posting Permissions

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