Mailmerge from Excel Datasource

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jan - 21 Mar 2006 19:41 GMT

I am currently doing a mailmerge to the Electoral Register and have set my
headers in Excel as Title, First Name, Last Name, Add 1, Add2, Add3, Postcode
etc. The problem is that the register contains different information in Add1,
Add2 and Add3 fields eg. Add1 may contain Flat 1, Add2, Street name and
Number, Add3 Town etc. My issue is, in Add1 on some fields it contains no
Flat number and shows information for Add2. I have tried putting the fields
on the same line but it does not look professional having London etc on the
same line as the address. Is there a code I can insert to insert a hard
return should the information differ. I did look at some of the codes
adajacent to the mergefields tab but could not see anything. Thank you, if
you can, of coure assist.

Reply to this Message

Doug Robbins - Word MVP - 21 Mar 2006 20:39 GMT

Use an If...then...Else... field construction to check for the presence of
data in a field. It is a bit hard to provide exactly the arrangement that
you will need because it is not clear whether, if in the absence of a Flat
number in the Add1 field if the town/city is in the Add2 or Add3 field. It
maybe the presence of data in the Add3 field that needs to be tested.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I am currently doing a mailmerge to the Electoral Register and have set my
> headers in Excel as Title, First Name, Last Name, Add 1, Add2, Add3,
[quoted text clipped - 12 lines]
> if
> you can, of coure assist.

Reply to this Message