Hi all,

Stuck on a iccle tiny little thing.

I'm on MS Office 2000 btw.

I have an xls spread sheet which I am using for a mail merge. This sreadsheet has the normal columns, email addy, postal address and a post letter flag.

Now I can quite happily mail merge and print those with print flag. What I'd like to do however is for those with print off, is actually create the document and mail it to them.

I'm not adverse to multiple mail merge runs or in fact using access if it will help in way...

Thoughts, tips or links welcomed.

Thanks in advance.

So you mail merge the ones with the "print" flag, and the others should be emailed?

I suppose you could stick in a macro to do this - possibly by linking in with outlook... testing might be a problem as you don't want to spam people...

Colin,

In mine when I go to word and do the mail merge, I can use a "skip record if" command, so in your example I could use skip record if "print" = "N" from the fields defined in Excel. Do a search on SKIPIF

That's Word 2003.

Not sure that helps.....

Seeing as you work for me I could let you have one of my 10 licenced copies of Office 2003 Pro

I can get office 2003 for about

Got the merge skipping the ones it does not need to print...I'm stuck on how to make the non printed ones email the same doc...

@Jon, Maybe I'd best send you that report I guess.

@Stimps: NHS? My trust won't :(