A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Mailmerge Days And Times



 
 
Thread Tools Display Modes
  #1  
Old March 22nd, 2010, 05:32 PM posted to microsoft.public.word.mailmerge.fields
Irwin109
external usenet poster
 
Posts: 9
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  
Old March 22nd, 2010, 11:27 PM posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,239
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  
Old March 23rd, 2010, 12:46 PM posted to microsoft.public.word.mailmerge.fields
Irwin109
external usenet poster
 
Posts: 9
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.
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:16 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.