[Irwin109]

It feels like this is my second most visited 'site besides Facebook!!!

Ok people, here's the problem this time:

I'm wanting a mailmerge to return the days and (in a seperate column of a
table) times. Let me elaborate...

I have mailmerge fields from my database called:
Monday_AM
Tuesday_AM
Wednesday_AM etc through to Sunday_AM
and the repeat of the week for the other four times, Monday_Lunch,
Monday_Tea and Monday_Bed, Monday_Sleepover.

I'm wondering if there's a way to get all these to return the result (for
example if there is a visit every day at every time)
Mon - Sun AM,Lunch,Tea,Bed,Sleepover

If they're not all selected it'd be something like

Mon/Tue/Thu/Fri AM, Lunch

If I need to explain this better I will as I suck at getting what I mean out
on the first go on this website, don't know why, maybe just 'cause I'm
swirling knowledge around in the hope of an answer!!!

Any response is greatly appreciated.

[Doug Robbins - Word MVP]

I gather that you are trying to do is concatenate the results, but do you
realise how many different possibilities there are?

I really think that the best way to present the information would be to use
an 8 column x 6 row table in your mail merge main document with days of the
week as the headings from columns 2 through 8 and the times as the row tiles
in rows 2 through 6 of column 1 and insert the appropriate mergefields into
the cells,

--
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, originally posted via msnews.microsoft.com

"Irwin109" wrote in message
...
It feels like this is my second most visited 'site besides Facebook!!!

Ok people, here's the problem this time:

I'm wanting a mailmerge to return the days and (in a seperate column of a
table) times. Let me elaborate...

I have mailmerge fields from my database called:
Monday_AM
Tuesday_AM
Wednesday_AM etc through to Sunday_AM
and the repeat of the week for the other four times, Monday_Lunch,
Monday_Tea and Monday_Bed, Monday_Sleepover.

I'm wondering if there's a way to get all these to return the result (for
example if there is a visit every day at every time)
Mon - Sun AM,Lunch,Tea,Bed,Sleepover

If they're not all selected it'd be something like

Mon/Tue/Thu/Fri AM, Lunch

If I need to explain this better I will as I suck at getting what I mean
out
on the first go on this website, don't know why, maybe just 'cause I'm
swirling knowledge around in the hope of an answer!!!

Any response is greatly appreciated.

[Irwin109]

Yeah, I figured it's a bit too much to type out every possibility for it! I
might have to just make the week and time table then, I had that in my head,
just the old layout of the mailmerge had the days on like I explained but my
database behind it was set up differently...

Thanks for the help though.