View Single Post
  #6   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Contro
 
Posts: n/a
Default Mail Merge all things to one page


The main problem is that the template has a very specific layout which
really isn't open to any change what so ever, not even minor changes,
and that to replicate it would be very hard, and I'm not sure totally
possible.

The other main problem is that producing it as a report would bring
it's own problems: there are other fields in the document, such as the
address details of who the results are being sent to, and the mail
merge picks up which fields are blank, and then misses them out;
doesn't print commas after these blank fields too; and also doesn't
print the country if the country is the the UK. This might well be
possible to do in a report, but I don't know how, and would then have
to research this too.

I didn't know you could combine two merges, or what not, using a macro
though. I shall have a look into this after trying out Cindy's
solution, as I am quite sure that does provide a solution, from the
example I posted; I just need to understand it.

Thanks for your help! I'll let you know on Tuesday how this goes, as I
won't be able to give it a try before then.

Contro.

Doug Robbins - Word MVP wrote:
Without seeing your template, I can't be sure, but I have created some very
complex reports in Access. In most of those cases, there was absolutely no
way that it could have been done using mailmerge.

Another alternative would be to use a couple of mailmerges, a formletter
merge and a catalog (or directory) merge and then use a macro to combine the
relevant parts of the catalog or directory merge with the documents created
by formletter merge.

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

"Contro" wrote in message
ups.com...
Thanks for your reply!

If only I could use a report; the document is in a complex template
which I do not think can be replicated in an Access Report.

I'm sure there is a way to get this working okay. I will need it for
another grade card, but only on another template.

Please keep the help coming!

Thank you once more.

Contro.