Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / April 2008

Tip: Looking for answers? Try searching our database.

merging addresses

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
JohnD - 17 Apr 2008 18:41 GMT
I am using word 2007 as my main document and outlook 2007 as my name and
address data sourse. I want to merge the address into the main document in
two places. The second place needs to apear all on the same lines ie

Like this in the first place

Name
Address
City
Post code

And like this in the second

Name Address City post code

When I try to do this after the merge is complete it moves the address, city
and post codes on to a new line below. Is there any way around this problem
Rich/rerat - 17 Apr 2008 19:54 GMT
JohnD,
Do not use the Address Block, you will need to insert individual mergefields
to the document.
1. Create your Data Source from the Contact folder using the Mail Merge
option, and select New Document.
2. When Word Starts:
3. On the Mail Merge toolbar> Under Mail Merge Recipients> Make sure that
the right ones are selected.
4. Select the Insert Merge Fields button. Do not use the Address Block.
Insert one item at a time, such as first_name, last_name,
home_address_street, etc...
5. Copy/Paste this string of merge fields down in the word document, by
hitting the ENTER key a couple of times.
6. Then add spacing to the mergefields as desired, and adding any text to
the letter or word document, such as this Example:

«First_Name» «Last_Name»

«Home_Address_Street»

«Home_Address_City», «Home_Address_State» «Home_Address_Postal_Code»

«Home_Phone»

How are you doing? (Line in Example to just show separation of the two (2)
Merge Field areas.)

«First_Name» «Last_Name» «Home_Address_Street» «Home_Address_City»
«Home_Address_State» «Home_Address_Postal_Code»

Sincerely Yours,

JohnD

7. Merge to New Document> Check for errors> Print Merged Document.

Signature

Add MS to your News Reader: news://msnews.microsoft.com
Rich/rerat
(RRR News)    <message rule>
<<Previous Text Snipped to Save Bandwidth When Appropriate>>

I am using word 2007 as my main document and outlook 2007 as my name and
address data sourse. I want to merge the address into the main document in
two places. The second place needs to apear all on the same lines ie

Like this in the first place

Name
Address
City
Post code

And like this in the second

Name Address City post code

When I try to do this after the merge is complete it moves the address, city
and post codes on to a new line below. Is there any way around this problem
JohnD - 18 Apr 2008 13:24 GMT
Thanks that was most helpfull and does work in most instances. The only
problem I have now is I am using outlook for my data source and if I merge
from a contact that also has a house name it is included in the address and
consequently moves part of the address onto a second line instead of all on
one line if you understand my meaning

> JohnD,
> Do not use the Address Block, you will need to insert individual mergefields
[quoted text clipped - 49 lines]
> When I try to do this after the merge is complete it moves the address, city
> and post codes on to a new line below. Is there any way around this problem
Graham Mayor - 18 Apr 2008 15:48 GMT
It is inevitable that if you have two lines of address in one of the fields
by including a line break in the field, you will get two lines of result in
the merge.
You *may* be able to adapt one or more of the custom fields to hold the
parts of the addresses you want to display if you merge from Outlook
http://www.gmayor.com/mailmerge_from_outlook.htm
The procedure is essentially that used to produce an initial shown near the
end of http://www.gmayor.com/merge_labels_with_word_2007.htm though how easy
it would be to automate the transfer of the parts of the address using a
macro similar to the one shown would rather depend on how your addresses are
organized.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Thanks that was most helpfull and does work in most instances. The
> only problem I have now is I am using outlook for my data source and
[quoted text clipped - 63 lines]
>> address, city and post codes on to a new line below. Is there any
>> way around this problem
Rich/rerat - 18 Apr 2008 23:12 GMT
JohnD,
Have you considered changing the margin settings, or font type or size for
your document? Or just change the font type or size for the text that you
want to appear as one line?

Signature

Add MS to your News Reader: news://msnews.microsoft.com
Rich/rerat
(RRR News)    <message rule>
<<Previous Text Snipped to Save Bandwidth When Appropriate>>

It is inevitable that if you have two lines of address in one of the fields
by including a line break in the field, you will get two lines of result in
the merge.
You *may* be able to adapt one or more of the custom fields to hold the
parts of the addresses you want to display if you merge from Outlook
http://www.gmayor.com/mailmerge_from_outlook.htm
The procedure is essentially that used to produce an initial shown near the
end of http://www.gmayor.com/merge_labels_with_word_2007.htm though how easy
it would be to automate the transfer of the parts of the address using a
macro similar to the one shown would rather depend on how your addresses are
organized.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

JohnD wrote:

> Thanks that was most helpfull and does work in most instances. The
> only problem I have now is I am using outlook for my data source and
[quoted text clipped - 65 lines]
>> address, city and post codes on to a new line below. Is there any
>> way around this problem
Graham Mayor - 19 Apr 2008 06:13 GMT
If the break is in the field, it won't matter how long the line is, it will
still break.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> JohnD,
> Have you considered changing the margin settings, or font type or
[quoted text clipped - 89 lines]
>>> address, city and post codes on to a new line below. Is there any
>>> way around this problem
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.