A Microsoft Outlook email forum. Outlook Banter

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.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook - Using Contacts
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Outlook contact to Word Mail Merge result blank line before City, State, Zip



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old October 4th 06, 06:34 PM posted to microsoft.public.outlook.contacts
Randy
external usenet poster
 
Posts: 2
Default Outlook contact to Word Mail Merge result blank line before City, State, Zip

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  
Old October 4th 06, 07:32 PM posted to microsoft.public.outlook.contacts
Randy
external usenet poster
 
Posts: 2
Default Outlook contact to Word Mail Merge result blank line before City, State, Zip

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  
Old October 4th 06, 07:53 PM posted to microsoft.public.outlook.contacts
Info
external usenet poster
 
Posts: 11
Default Outlook contact to Word Mail Merge result blank line before City,

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  
Old October 4th 06, 10:37 PM posted to microsoft.public.outlook.contacts
Russ Valentine [MVP-Outlook]
external usenet poster
 
Posts: 9,348
Default Outlook contact to Word Mail Merge result blank line before City, State, Zip

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  
Old October 4th 06, 10:39 PM posted to microsoft.public.outlook.contacts
Russ Valentine [MVP-Outlook]
external usenet poster
 
Posts: 9,348
Default Outlook contact to Word Mail Merge result blank line before City,

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  
Old October 4th 06, 11:31 PM posted to microsoft.public.outlook.contacts
Info
external usenet poster
 
Posts: 11
Default Outlook contact to Word Mail Merge result blank line before Ci

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  
Old October 5th 06, 01:37 AM posted to microsoft.public.outlook.contacts
Russ Valentine [MVP-Outlook]
external usenet poster
 
Posts: 9,348
Default Outlook contact to Word Mail Merge result blank line before Ci

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
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


All times are GMT +1. The time now is 07:18 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.