Simple Mail Merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sonia - 11 Nov 2007 20:13 GMT

Going crazy. I cannot seem to get the fields in the right place. I ask for
'contact', it produces 'postal_code". I ask for 'city', "province" and
it puts province on the next line. It's just doin its own thing. LOl. I
have started from scratch at least 4 times. NO idea what I am doing wrong.

Reply to this Message

Doug Robbins - Word MVP - 11 Nov 2007 22:57 GMT

Are you using the AddressBlock? If so, don't. Insert the fields that you
want to use in the configuration that you want them.

If you are merging from Outlook as sounds probable, see the "Mailmerge from
Outlook" item on fellow MVP Graham Mayor's website at:

http://www.gmayor.com/mailmerge_from_outlook.htm

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

> Going crazy. I cannot seem to get the fields in the right place. I ask
> for
[quoted text clipped - 4 lines]
> have started from scratch at least 4 times. NO idea what I am doing
> wrong.

Reply to this Message

Sonia - 12 Nov 2007 04:54 GMT

Thanks for the quick response.
No, I am using excel.
The coloumn headings are inserted into the document using a drop down list.
It DOES inport the data, but not necessarily from the right column, and not
in the place that I request it. I tried narrowing down the problem by
starting over, and asking in for <<CONTACT>> for example, and after the mail
merge, what it inported was the Postal code column. Weird eh? I even went
so far as to reboot my computer. Nothing works. The merge keeps inporting
from the wrong column AND not following my requested locations IE (It
displays city, beside address, when I have clearly requested city on the line
below address)

> Are you using the AddressBlock? If so, don't. Insert the fields that you
> want to use in the configuration that you want them.
[quoted text clipped - 12 lines]
> > have started from scratch at least 4 times. NO idea what I am doing
> > wrong.

Reply to this Message

Doug Robbins - Word MVP - 12 Nov 2007 09:51 GMT

I think that I have heard that this problem can be caused by a corruption in
the Excel spreadsheet. Try copying the data to a new workbook and try using
that as a data source.

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

> Thanks for the quick response.
> No, I am using excel.
[quoted text clipped - 34 lines]
>> > have started from scratch at least 4 times. NO idea what I am doing
>> > wrong.

Reply to this Message