Results 1 to 14 of 14
  1. #1
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Bedford, Texas, USA
    Posts
    310
    Thanks
    1
    Thanked 0 Times in 0 Posts

    EnvelopeExtra (Office 2003 SP1)

    For some time I have been printing my envelopes using EnvelopeExtra1. This AutoText entry contains a logo and a return address. I can't figure out how to turn that entry off without losing it completely. On occasion I need to print an envelope that already had the return address printed on the envelope. I want to delete my EnvelopeExtra1 entry for this one envelope only.
    Looking at my Envelope window (Tools>Letters and Mailings>Envelopes and Labels>Envelopes), I see my return address in the Return Address area and a check mark in Omit. With this configuration, my envelope prints showing my logo and address named EnvelopeExtra1.
    I tried creating a blank return address by opening a new Word document, hitting my Enter key three times, choosing the three Paragraph Marks and naming them as a new AutoText entry called EnvelopeExtra2.
    Going to Tools, etc. again, I didn't find a choice of using either EnvelopeExtra1 or 2. I looked at Insert>AutoText>Return Address and found only the EnvelopeExtra1 option.

    I'm sure someone has the answer to this question. I can't be the only person who wants to generate an envelope with no return address occasionally.

    Thanks.
    Barbara<div align='center'></div>

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

    Re: EnvelopeExtra (Office 2003 SP1)

    Word will always print EnvelopeExtra1 and EnvelopeExtra2 on an envelope, if available. The only way to turn them off is to delete both AutoText entries.

    See for example Alternative Return Addresses.

  3. #3
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Bedford, Texas, USA
    Posts
    310
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: EnvelopeExtra (Office 2003 SP1)

    Thank you, Hans, for replying. Guess my question wasn't as simple to solve as I had hoped. You gave me three ways to print an envelope without the return address while preserving my graphic return address.

    Since I very seldom need to print an envelope without my graphic return, I experimented a little more and decided I can accomplish this by adding the envelope to a document, clicking on the graphic and deleting it. Then, I click on my text return address and delete it.

    While reading your reply, I clicked on your Downloads link and found the answer to another matter that has been irritating me...deleting the PDF toolbar from opening with Word! I didn't know that bothered anyone but me. I not only feel better, now I know how to delete it. Thank you so much.

    This Forum is a great place to find answers.

    <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    Barbara<div align='center'></div>

  4. #4
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Zoetermeer, Zuid-Holland, Netherlands
    Posts
    559
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: EnvelopeExtra (Office 2003 SP1)

    What you want is possible with a little macro. Make an AutoText entry for every return address you need. Make an AutoText entry called EnvelopeExtra1 with the same content as one of the other entries. Programmatically you can set the Value (content) of EnvelopeExtra1 to be equal to that of another entry. You can choose which entry with a click on a userform.
    See attached zipped template for an example. I tested it with text-only AutoText entries and that worked fine. Have to go now, so no more time now to test it with graphics. I'll keep my fngers crossed... If you like this, edit it the way you want it and copy things to your Normal.dot or the template you are using. AutoText entries can only be saved in a template, not a document.
    Attached Files Attached Files

  5. #5
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Bedford, Texas, USA
    Posts
    310
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: EnvelopeExtra (Office 2003 SP1)

    This template is awesome.

    I'm way out of my league, however. I don't know how to implement it or to work with macros. If explaining it is too complicated, don't worry with it any more.
    Thanks so much for your reply. There are surely a lot of clever people who frequent this Forum.
    Barbara<div align='center'></div>

  6. #6
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Zoetermeer, Zuid-Holland, Netherlands
    Posts
    559
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: EnvelopeExtra (Office 2003 SP1)

    <P ID="edit" class=small>(Edited by JanB on 24-Aug-05 10:25. corrected typo's)</P>As I said, yesterday I didn't have time to test it with AutoText entries containing graphics. I just tested that and unfortunately that doesn't work. <img src=/S/sad.gif border=0 alt=sad width=15 height=15>
    The graphic is lost in the copy proces and substituted by an asterisk... So, I wonder if you're still interested in this not-so-complete solution.

  7. #7
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Bedford, Texas, USA
    Posts
    310
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: EnvelopeExtra (Office 2003 SP1)

    Jan, thank you for taking the time to test and reply to me. I appreciate it.

    I obviously need to learn a lot more about Word than I know now.

    Thank you again.
    Barbara<div align='center'></div>

  8. #8
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Zoetermeer, Zuid-Holland, Netherlands
    Posts
    559
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: EnvelopeExtra (Office 2003 SP1)

    Well, I got another brainwave for a solution, including graphics this time. It needs some more testing, but the proof of concept worked. <img src=/S/yep.gif border=0 alt=yep width=15 height=15>
    Also I want to prepare a short "how to" with a list of steps to implement that solution in your Normal.dot or another template. Stay tuned...

  9. #9
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Bedford, Texas, USA
    Posts
    310
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: EnvelopeExtra (Office 2003 SP1)

    Thank you, Jan!

    I'll wait to hear the results of your brainwave.
    Barbara<div align='center'></div>

  10. #10
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Zoetermeer, Zuid-Holland, Netherlands
    Posts
    559
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: EnvelopeExtra (Office 2003 SP1)

    Attached is a new version of ReturnAddress.dot that uses a different approach. Instead of copying the content of one AutoText entry to another, it now renames the appropriate AutoText entry. I set this up for max. 3 return addresses. If more are desired, the form and macro
    Attached Files Attached Files

  11. #11
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Bedford, Texas, USA
    Posts
    310
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: EnvelopeExtra (Office 2003 SP1)

    <img src=/S/fanfare.gif border=0 alt=fanfare width=31 height=23> <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23> Jan,
    You are so clever!!! Your ReturnAddress template works beautifully!. Not only that, you were also able to explain to me EXACTLY how to implement it.
    I am very happy. Thank you again.
    One suggestion: it was also necessary to delete the EnvelopeExtra1 AutoText from the Normal template before it worked for me.
    This must have taken some hours of your time to figure this out and I really appreciate it.
    Barbara<div align='center'></div>

  12. #12
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: EnvelopeExtra (Office 2003 SP1)

    Hi Jan:
    For some reason, when I use your template, I get a message "the requested member of the collection does not exist". In trying to debug it, the line

    For Each ate In Templates(strTmpl).AutoTextEntries

    is highlighted. Do you know what's going on? (I'm using Word 2003).

    Whoops! I tried loading it as an add-in, rather than place in the startup folder. Only works when it's in the startup folder, not as an add-in. Could you explain why?
    Thanks,

  13. #13
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Zoetermeer, Zuid-Holland, Netherlands
    Posts
    559
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: EnvelopeExtra (Office 2003 SP1)

    Hi Phil,
    No, I can't. I seldom use add-ins. All my code is in one globel template in the startup folder.

  14. #14
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Zoetermeer, Zuid-Holland, Netherlands
    Posts
    559
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: EnvelopeExtra (Office 2003 SP1)

    You're welcome.
    And you're right, of course, about the AutoText entry EnvelopeExtra1 in Normal.dot. I should have thought about that myself.

Posting Permissions

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