Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Formulas?
I have been requested to create a merge document. One of the fields that is
being requested is to calculate a date in the future (5 days from today, 89 days from, etc.). Can you create a field in a merge document that would calculate something like that? If so, how would one do it? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Formulas?
If possible, do this in your data source - e.g. if it's an Access/SQL Server
database, make a query/view that calculates date+5 or date+89, use that as the data source and insert that field just like any other. That won't work unless you know the number of days you need to add at the point when the query is executed (which you may not know if, for example, the user types the value into an ASK field). Otherwise, download the macropod's attachment at : http://www.wopr.com/cgi-bin/w3t/show...?Number=249902 You may also find http://tips.pjmsn.me.uk/t0004.htm useful. Peter Jamieson "cbremar" wrote in message ... I have been requested to create a merge document. One of the fields that is being requested is to calculate a date in the future (5 days from today, 89 days from, etc.). Can you create a field in a merge document that would calculate something like that? If so, how would one do it? |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Formulas?
I wish I could do that, but the data source, an Excel spreadsheet, will be
controlled by someone else. Thanks for the links. I'll take a look at them to see if they contain what I need. In the meantime, do you know how I would set up the merge field to calculate this info? Thanks again. "Peter Jamieson" wrote: If possible, do this in your data source - e.g. if it's an Access/SQL Server database, make a query/view that calculates date+5 or date+89, use that as the data source and insert that field just like any other. That won't work unless you know the number of days you need to add at the point when the query is executed (which you may not know if, for example, the user types the value into an ASK field). Otherwise, download the macropod's attachment at : http://www.wopr.com/cgi-bin/w3t/show...?Number=249902 You may also find http://tips.pjmsn.me.uk/t0004.htm useful. Peter Jamieson "cbremar" wrote in message ... I have been requested to create a merge document. One of the fields that is being requested is to calculate a date in the future (5 days from today, 89 days from, etc.). Can you create a field in a merge document that would calculate something like that? If so, how would one do it? |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Formulas?
In the meantime, do you know how I would
set up the merge field to calculate this info? The trouble is that the calculation using fields is not at all simple, which is why you need the stuff in he (it shows you how to do the calculations using fields): http://www.wopr.com/cgi-bin/w3t/show...?Number=249902 I wish I could do that, but the data source, an Excel spreadsheet, will be controlled by someone else. You may still be able to do the calculation "in the data source" using Word VBA to issue the necessary Jet SQL. It's described in the other article. Peter Jamieson "cbremar" wrote in message ... I wish I could do that, but the data source, an Excel spreadsheet, will be controlled by someone else. Thanks for the links. I'll take a look at them to see if they contain what I need. In the meantime, do you know how I would set up the merge field to calculate this info? Thanks again. "Peter Jamieson" wrote: If possible, do this in your data source - e.g. if it's an Access/SQL Server database, make a query/view that calculates date+5 or date+89, use that as the data source and insert that field just like any other. That won't work unless you know the number of days you need to add at the point when the query is executed (which you may not know if, for example, the user types the value into an ASK field). Otherwise, download the macropod's attachment at : http://www.wopr.com/cgi-bin/w3t/show...?Number=249902 You may also find http://tips.pjmsn.me.uk/t0004.htm useful. Peter Jamieson "cbremar" wrote in message ... I have been requested to create a merge document. One of the fields that is being requested is to calculate a date in the future (5 days from today, 89 days from, etc.). Can you create a field in a merge document that would calculate something like that? If so, how would one do it? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
WANT TO LEARN ABOUT USING ALL FORMULAS | Tables | |||
formulas in Word | Microsoft Word Help | |||
labels and formulas | Microsoft Word Help | |||
Formulas in Word | Microsoft Word Help | |||
Getting rid of zeros in formulas | Tables |