Mail merge queries: Word 07

[Boppy]

Hi guys, I am doing a mail merge with two A6 pages per A4 page (they
will be the inside pages on some cards I have pre-printed). Because I
want two letters per page, I have inserted a Continuous Section Break
rather than a page break.

How can I have the merge engine treat a section break as a page break
as far as merge data goes? My first attempt has Dear Mark and Dear
Mark on the same page, whereas it should be Dear Mark at top and Dear
Nina at bottom.

The other problem is filtering my merge data by date. This is a
screenshot of the error I get when trying to filter by Entered date,
which as you can see clearly matches what I have typed:
http://i30.tinypic.com/2uz40h4.jpg
Is there a particular format Word wants us to put dates in?

Thanks in advanace to anyone who can save my sanity and help me finish
this mailout before everyone's birthday has been and gone

B

 

[macropod]

Hi Boppy,

You may do better to run the merge with only one record per page, then change the section breaks created by the merge process to
column breaks afterwards. You can use Find/Replace for this, where:
Find Text = "^b"
Replacement Text = "^n"

Cheers

 

[Boppy]

Hi Boppy,

You may do better to run the merge with only one record per page, then change the section breaks created by the merge process to
column breaks afterwards. You can use Find/Replace for this, where:
Find Text = "^b"
Replacement Text = "^n"

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

Hi guys, I am doing a mail merge with two A6 pages per A4 page (they
will be the inside pages on some cards I have pre-printed). Because I
want two letters per page, I have inserted a Continuous Section Break
rather than a page break.

How can I have the merge engine treat a section break as a page break
as far as merge data goes? My first attempt has Dear Mark and Dear
Mark on the same page, whereas it should be Dear Mark at top and Dear
Nina at bottom.

The other problem is filtering my merge data by date. This is a
screenshot of the error I get when trying to filter by Entered date,
which as you can see clearly matches what I have typed:
http://i30.tinypic.com/2uz40h4.jpg
Is there a particular format Word wants us to put dates in?

Thanks in advanace to anyone who can save my sanity and help me finish
this mailout before everyone's birthday has been and gone

B

Hi Macropod, thanks for your reply. I did some thinking and have found
this solution: use the <<next record>> code and then I can print two
letters per page.

Am still flummoxed by the date filtering though - I can filter dates
fine when I have typed it in as text in a Word table. It's when I
import the data file from Excel that Word has a problem. I'll head
over to the Excel group and post the question to them.

B