![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
![]()
Here is the problem.
1. Create an Outlook Contact like this: Full Name: John Smith Business: Suite B 123 Main St. Anywhere, CA 90210 2. Select the newly created contact and go to Tools - Mail Merge. Choose "Only selected contacts", Document Type Envelopes, click Ok. 3. Once Word starts Complete the setup, click setup, choose the default Size 10 envelope, click OK, click Close. 4. In the envelope add the default Address Block. 5. Click "View merged data" button. Here is the output: John Smith Suite B 123 Main St. Anywhere, CA 90210 Notice the blank line before the City,State Zip line. Now start over and start from Word. 1. New document. 2. Click Tools-Letters and Mailings-Mail Merge 3. Select Envelopes for document type. 4. Click Next: Starting document 5. Click Envelope Options, click OK. 6. Click Next: Select Recipients. 7. Choose "Select from Outlook contacts. 8. Click "Choose Contacts Folder" 9. Select your Contact folder that has the above entry. 10. Only select the entry above. 11. Click Next: Arrange your envelope 12. Select the address area of the envelope and click Address block, just accept the default. 13. Click Next: Preview your envelope Notice it looks like this: John Smith Suite B 123 Main St. Anywhere, CA 90210 Just like you want it without the extra blank line. So why doesn't it work this way when Mail Merge is started from Outlook? It does not matter how you arrange the address street information if you have multiple lines, you end up with this blank line if you start the mail merge from Outlook, but you don't have the extra line if the mail merge is started from Word, even though the data source is the same. |
Ads |
#2
|
|||
|
|||
![]()
BTW, this is Outlook and Word 2003 fully patched/updated from Office
Small Business Edition 2003. Randy wrote: Here is the problem. 1. Create an Outlook Contact like this: Full Name: John Smith Business: Suite B 123 Main St. Anywhere, CA 90210 Here is the output: John Smith Suite B 123 Main St. Anywhere, CA 90210 Notice the blank line before the City,State Zip line. Notice it looks like this: John Smith Suite B 123 Main St. Anywhere, CA 90210 Just like you want it without the extra blank line. So why doesn't it work this way when Mail Merge is started from Outlook? It does not matter how you arrange the address street information if you have multiple lines, you end up with this blank line if you start the mail merge from Outlook, but you don't have the extra line if the mail merge is started from Word, even though the data source is the same. |
#3
|
|||
|
|||
![]()
Please help,
I am trying to do an address label mail merge by categories in Outlook. When I select the category then Tools, Mail Merge. I choose only selected contacts, then Mailing labels. On the Mail Merge helper when I select my Outlook Contacts for the Data Source, my computer immediately runs a virus scan and the merge doesn't go through. Any idea what is going on? "Randy" wrote: Here is the problem. 1. Create an Outlook Contact like this: Full Name: John Smith Business: Suite B 123 Main St. Anywhere, CA 90210 2. Select the newly created contact and go to Tools - Mail Merge. Choose "Only selected contacts", Document Type Envelopes, click Ok. 3. Once Word starts Complete the setup, click setup, choose the default Size 10 envelope, click OK, click Close. 4. In the envelope add the default Address Block. 5. Click "View merged data" button. Here is the output: John Smith Suite B 123 Main St. Anywhere, CA 90210 Notice the blank line before the City,State Zip line. Now start over and start from Word. 1. New document. 2. Click Tools-Letters and Mailings-Mail Merge 3. Select Envelopes for document type. 4. Click Next: Starting document 5. Click Envelope Options, click OK. 6. Click Next: Select Recipients. 7. Choose "Select from Outlook contacts. 8. Click "Choose Contacts Folder" 9. Select your Contact folder that has the above entry. 10. Only select the entry above. 11. Click Next: Arrange your envelope 12. Select the address area of the envelope and click Address block, just accept the default. 13. Click Next: Preview your envelope Notice it looks like this: John Smith Suite B 123 Main St. Anywhere, CA 90210 Just like you want it without the extra blank line. So why doesn't it work this way when Mail Merge is started from Outlook? It does not matter how you arrange the address street information if you have multiple lines, you end up with this blank line if you start the mail merge from Outlook, but you don't have the extra line if the mail merge is started from Word, even though the data source is the same. |
#4
|
|||
|
|||
![]()
This is a Word question. It would probably be worth your reading how to
control how addresses are inserted into Word: http://www.slipstick.com/contacts/insword.htm http://support.microsoft.com/default...;en-us;q134901 If you need more help, I'd suggest a Word group. -- Russ Valentine [MVP-Outlook] "Randy" wrote in message oups.com... Here is the problem. 1. Create an Outlook Contact like this: Full Name: John Smith Business: Suite B 123 Main St. Anywhere, CA 90210 2. Select the newly created contact and go to Tools - Mail Merge. Choose "Only selected contacts", Document Type Envelopes, click Ok. 3. Once Word starts Complete the setup, click setup, choose the default Size 10 envelope, click OK, click Close. 4. In the envelope add the default Address Block. 5. Click "View merged data" button. Here is the output: John Smith Suite B 123 Main St. Anywhere, CA 90210 Notice the blank line before the City,State Zip line. Now start over and start from Word. 1. New document. 2. Click Tools-Letters and Mailings-Mail Merge 3. Select Envelopes for document type. 4. Click Next: Starting document 5. Click Envelope Options, click OK. 6. Click Next: Select Recipients. 7. Choose "Select from Outlook contacts. 8. Click "Choose Contacts Folder" 9. Select your Contact folder that has the above entry. 10. Only select the entry above. 11. Click Next: Arrange your envelope 12. Select the address area of the envelope and click Address block, just accept the default. 13. Click Next: Preview your envelope Notice it looks like this: John Smith Suite B 123 Main St. Anywhere, CA 90210 Just like you want it without the extra blank line. So why doesn't it work this way when Mail Merge is started from Outlook? It does not matter how you arrange the address street information if you have multiple lines, you end up with this blank line if you start the mail merge from Outlook, but you don't have the extra line if the mail merge is started from Word, even though the data source is the same. |
#5
|
|||
|
|||
![]()
I think you may be confused. Why would you ever need to select your data
source when you already specified it in advance? -- Russ Valentine [MVP-Outlook] "Info" wrote in message ... Please help, I am trying to do an address label mail merge by categories in Outlook. When I select the category then Tools, Mail Merge. I choose only selected contacts, then Mailing labels. On the Mail Merge helper when I select my Outlook Contacts for the Data Source, my computer immediately runs a virus scan and the merge doesn't go through. Any idea what is going on? "Randy" wrote: Here is the problem. 1. Create an Outlook Contact like this: Full Name: John Smith Business: Suite B 123 Main St. Anywhere, CA 90210 2. Select the newly created contact and go to Tools - Mail Merge. Choose "Only selected contacts", Document Type Envelopes, click Ok. 3. Once Word starts Complete the setup, click setup, choose the default Size 10 envelope, click OK, click Close. 4. In the envelope add the default Address Block. 5. Click "View merged data" button. Here is the output: John Smith Suite B 123 Main St. Anywhere, CA 90210 Notice the blank line before the City,State Zip line. Now start over and start from Word. 1. New document. 2. Click Tools-Letters and Mailings-Mail Merge 3. Select Envelopes for document type. 4. Click Next: Starting document 5. Click Envelope Options, click OK. 6. Click Next: Select Recipients. 7. Choose "Select from Outlook contacts. 8. Click "Choose Contacts Folder" 9. Select your Contact folder that has the above entry. 10. Only select the entry above. 11. Click Next: Arrange your envelope 12. Select the address area of the envelope and click Address block, just accept the default. 13. Click Next: Preview your envelope Notice it looks like this: John Smith Suite B 123 Main St. Anywhere, CA 90210 Just like you want it without the extra blank line. So why doesn't it work this way when Mail Merge is started from Outlook? It does not matter how you arrange the address street information if you have multiple lines, you end up with this blank line if you start the mail merge from Outlook, but you don't have the extra line if the mail merge is started from Word, even though the data source is the same. |
#6
|
|||
|
|||
![]()
Russ,
Here is my real issue: In Outlook Contacts, I begin in By Category View then I select my Category, go to Tools, Mail Merge, then I click on "Only Selected Contacts" & "Contact field in current view", select Mailing Labels, then Hit OK, this initiates Outlook brings up the Mail Merge Helper but the Merge Tab is light gray and I am not able to click it. How can I fix this? Thanks, Mike "Russ Valentine [MVP-Outlook]" wrote: I think you may be confused. Why would you ever need to select your data source when you already specified it in advance? -- Russ Valentine [MVP-Outlook] "Info" wrote in message ... Please help, I am trying to do an address label mail merge by categories in Outlook. When I select the category then Tools, Mail Merge. I choose only selected contacts, then Mailing labels. On the Mail Merge helper when I select my Outlook Contacts for the Data Source, my computer immediately runs a virus scan and the merge doesn't go through. Any idea what is going on? "Randy" wrote: Here is the problem. 1. Create an Outlook Contact like this: Full Name: John Smith Business: Suite B 123 Main St. Anywhere, CA 90210 2. Select the newly created contact and go to Tools - Mail Merge. Choose "Only selected contacts", Document Type Envelopes, click Ok. 3. Once Word starts Complete the setup, click setup, choose the default Size 10 envelope, click OK, click Close. 4. In the envelope add the default Address Block. 5. Click "View merged data" button. Here is the output: John Smith Suite B 123 Main St. Anywhere, CA 90210 Notice the blank line before the City,State Zip line. Now start over and start from Word. 1. New document. 2. Click Tools-Letters and Mailings-Mail Merge 3. Select Envelopes for document type. 4. Click Next: Starting document 5. Click Envelope Options, click OK. 6. Click Next: Select Recipients. 7. Choose "Select from Outlook contacts. 8. Click "Choose Contacts Folder" 9. Select your Contact folder that has the above entry. 10. Only select the entry above. 11. Click Next: Arrange your envelope 12. Select the address area of the envelope and click Address block, just accept the default. 13. Click Next: Preview your envelope Notice it looks like this: John Smith Suite B 123 Main St. Anywhere, CA 90210 Just like you want it without the extra blank line. So why doesn't it work this way when Mail Merge is started from Outlook? It does not matter how you arrange the address street information if you have multiple lines, you end up with this blank line if you start the mail merge from Outlook, but you don't have the extra line if the mail merge is started from Word, even though the data source is the same. |
#7
|
|||
|
|||
![]()
Well you jumped into this thread without specifying your Outlook and Word
version. No current versions even use the Mail Merge Helper. They all use the Mail Merge Task Pane or Mail Merge Toolbar. I suspect you are yet another victim of Microsoft's stunning incompetence when it comes to integration between its Office applications. Some versions still throw the Mail Merge dialog even though it is now obsolete. -- Russ Valentine [MVP-Outlook] "Info" wrote in message ... Russ, Here is my real issue: In Outlook Contacts, I begin in By Category View then I select my Category, go to Tools, Mail Merge, then I click on "Only Selected Contacts" & "Contact field in current view", select Mailing Labels, then Hit OK, this initiates Outlook brings up the Mail Merge Helper but the Merge Tab is light gray and I am not able to click it. How can I fix this? Thanks, Mike "Russ Valentine [MVP-Outlook]" wrote: I think you may be confused. Why would you ever need to select your data source when you already specified it in advance? -- Russ Valentine [MVP-Outlook] "Info" wrote in message ... Please help, I am trying to do an address label mail merge by categories in Outlook. When I select the category then Tools, Mail Merge. I choose only selected contacts, then Mailing labels. On the Mail Merge helper when I select my Outlook Contacts for the Data Source, my computer immediately runs a virus scan and the merge doesn't go through. Any idea what is going on? "Randy" wrote: Here is the problem. 1. Create an Outlook Contact like this: Full Name: John Smith Business: Suite B 123 Main St. Anywhere, CA 90210 2. Select the newly created contact and go to Tools - Mail Merge. Choose "Only selected contacts", Document Type Envelopes, click Ok. 3. Once Word starts Complete the setup, click setup, choose the default Size 10 envelope, click OK, click Close. 4. In the envelope add the default Address Block. 5. Click "View merged data" button. Here is the output: John Smith Suite B 123 Main St. Anywhere, CA 90210 Notice the blank line before the City,State Zip line. Now start over and start from Word. 1. New document. 2. Click Tools-Letters and Mailings-Mail Merge 3. Select Envelopes for document type. 4. Click Next: Starting document 5. Click Envelope Options, click OK. 6. Click Next: Select Recipients. 7. Choose "Select from Outlook contacts. 8. Click "Choose Contacts Folder" 9. Select your Contact folder that has the above entry. 10. Only select the entry above. 11. Click Next: Arrange your envelope 12. Select the address area of the envelope and click Address block, just accept the default. 13. Click Next: Preview your envelope Notice it looks like this: John Smith Suite B 123 Main St. Anywhere, CA 90210 Just like you want it without the extra blank line. So why doesn't it work this way when Mail Merge is started from Outlook? It does not matter how you arrange the address street information if you have multiple lines, you end up with this blank line if you start the mail merge from Outlook, but you don't have the extra line if the mail merge is started from Word, even though the data source is the same. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to direct output from Word mail merge to multiple Word documents | [email protected] | Outlook - General Queries | 3 | August 11th 06 04:10 AM |
contacts in several folders by State. How to merge into one? | Lisa | Outlook - Using Contacts | 1 | June 15th 06 05:43 PM |
Mapping of zip/postal code and city field reversed | John H Gamborg | Outlook - Using Contacts | 6 | May 16th 06 09:28 AM |
blank Word document in Mail Merge | jms00 | Outlook - Using Contacts | 3 | May 12th 06 02:38 PM |
transfer of zip code to word with mail merge doesn't work | Ken | Outlook - Using Contacts | 1 | April 25th 06 08:48 PM |