Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Irwin109 Irwin109 is offline
external usenet poster
 
Posts: 2
Default Mailmerge Days And Times

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.
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Mailmerge Days And Times

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.


  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Irwin109 Irwin109 is offline
external usenet poster
 
Posts: 2
Default Mailmerge Days And Times

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.
Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I calculate days to the calendar eg. today + 65 days =? LMH Microsoft Word Help 2 March 26th 08 07:26 AM
Checkboxes- From 10 days ago... DH Page Layout 3 April 26th 07 01:33 PM
Add days kaybee717 Microsoft Word Help 1 February 6th 07 09:56 PM
Font "Times New Roman" switches to "Times" without warning. Charm Microsoft Word Help 0 October 20th 06 03:50 PM
Calculate 95 days ago tjtjjtjt Microsoft Word Help 2 January 17th 06 04:42 PM


All times are GMT +1. The time now is 12:23 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"