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