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 » Search Forums
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Showing results 1 to 25 of 100
Search took 4.98 seconds.
Search: Posts made by: macropod[_2_]
Forum: General Discussion June 6th, 2010, 08:47 AM Posted to microsoft.public.word.docmanagement
Replies: 1
Views: 420
Posted By macropod[_2_]
hyperlinks

Hi alex,

To see how to implement relative paths in Word, check out the solution I've posted at:
http://lounge.windowssecrets.com/index.php?showtopic=670027

--
Cheers
macropod
[Microsoft MVP - Word]
Forum: Mailmerge June 5th, 2010, 09:58 AM Posted to microsoft.public.word.mailmerge.fields
Replies: 3
Views: 1,977
Posted By macropod[_2_]
Setting minimum character limit?

Hi Cindy,

If you put the mergefield into a table cell with a fixed width & height, just sufficient for the # characters you want, that will
effectively limit the displayed output to a fixed width...
Forum: Mailmerge May 18th, 2010, 10:42 AM Posted to microsoft.public.word.mailmerge.fields
Replies: 4
Views: 392
Posted By macropod[_2_]
Weekday from text date

Hi Walter,

You can convert your field value to a day name via the mailmerge process, using a field in Word coded as:
{QUOTE{={Mergefield MyDate}*100 \# "00'-'00'-'{DATE \@ "YYYY"}"} \@ "DDDD"}
and...
Forum: General Discussions May 15th, 2010, 12:36 PM Posted to microsoft.public.office.misc
Replies: 2
Views: 382
Posted By macropod[_2_]
Office XP Mail Merge Spacing

Hi windrider,

Check what's between the mergefields - you might find a tab or multiple spaces where you want a single space.

--
Cheers
macropod
[Microsoft MVP - Word]
Forum: General Discussion May 15th, 2010, 12:29 PM Posted to microsoft.public.word.docmanagement
Replies: 5
Views: 218
Posted By macropod[_2_]
Calculate Form Fields

Hi NFL,

Beware of trying to reference a formfield calculation in a subsequent formfield. The results are unlikely to be what you'd expect.

--
Cheers
macropod
[Microsoft MVP - Word]
Forum: General Discussions May 6th, 2010, 09:47 AM Posted to microsoft.public.office.misc
Replies: 4
Views: 251
Posted By macropod[_2_]
try to unlock it with word password recvoery 5.0

Maggie chen: Yet another shameless plug for software the OP doesn't need. Please stop wasting everyone's time ...

--
Cheers
macropod
[Microsoft MVP - Word]


"Maggie chen" wrote in message...
Forum: General Discussions May 6th, 2010, 09:45 AM Posted to microsoft.public.office.misc
Replies: 12
Views: 1,071
Posted By macropod[_2_]
Try to unlock microsoft word password with Word Password Recovery 5.0

Maggie chen,

Once again, a reply that is of no worth at all in addressing the OP's problem - did you even bother to take the time to understand
the issue? And how about responding to something that...
Forum: General Discussion May 6th, 2010, 05:38 AM Posted to microsoft.public.word.docmanagement
Replies: 1
Views: 129
Posted By macropod[_2_]
Can I create a macro to crop a picture?

Hi Donna,

Here's a macro to crop a given amount of each side of a picture and then zoom in by the amount cropped.

Sub Demo()
Dim sngHeight, sngWidth, sngCrop As Single
sngCrop = 0.1
With...
Forum: Mailmerge May 6th, 2010, 02:34 AM Posted to microsoft.public.word.mailmerge.fields
Replies: 10
Views: 542
Posted By macropod[_2_]
leading zeros in mail merge

Hi dp,

The following field code correctly formats 5-digit and 5+4-digit Zip Code data, even where the source data may have incorrect
formatting such as a hyphen followed by trailing 0s after plain...
Forum: Tables May 4th, 2010, 06:37 AM Posted to microsoft.public.word.tables
Replies: 2
Views: 372
Posted By macropod[_2_]
Can table cells shading be conditional on data in a merge database

Alternatively, one could use an If...then...Else field construction to output different tables, shaded according to whatever the
colouring criteria are.

--
Cheers
macropod
[Microsoft MVP -...
Forum: General Discussion April 23rd, 2010, 09:52 AM Posted to microsoft.public.word.docmanagement
Replies: 11
Views: 251
Posted By macropod[_2_]
Calculate results of dropdown boxes in table

Hi Elaine,

Here's a different approach:
1. In each cell, insert a manual line break, followed by a REF field in the form of {REF Dropdown#}, where # is the Dropdown's
bookmark number.
2. Format...
Forum: Mailmerge April 23rd, 2010, 08:45 AM Posted to microsoft.public.word.mailmerge.fields
Replies: 11
Views: 578
Posted By macropod[_2_]
How to fill a word table with merge fields.

Hi ibmm,

Are you sure the merged document is the active one when you run the macro?

--
Cheers
macropod
[Microsoft MVP - Word]
Forum: Mailmerge April 17th, 2010, 10:53 PM Posted to microsoft.public.word.mailmerge.fields
Replies: 11
Views: 578
Posted By macropod[_2_]
How to fill a word table with merge fields.

Hi Doug,

It can present the data in tabular form.
Yes, but as far as I can see, it doesn't actually create a table, or am I missing something?

--
Cheers
macropod
[Microsoft MVP - Word]
Forum: General Discussion April 16th, 2010, 11:11 PM Posted to microsoft.public.word.docmanagement
Replies: 3
Views: 111
Posted By macropod[_2_]
Merged letter and made changes to merged letters. Final merged doc

Hi Serena,

In your mailmerge main document, select the date field, press Ctrl-F9 to enclose it in a pair for field braces (eg { 01-05-2010})
and type 'QUOTE' inside the braces, so that you end up...
Forum: Mailmerge April 16th, 2010, 11:05 PM Posted to microsoft.public.word.mailmerge.fields
Replies: 11
Views: 578
Posted By macropod[_2_]
How to fill a word table with merge fields.

Hi Doug,

But that still doesn't generate a table for the OP ...

--
Cheers
macropod
[Microsoft MVP - Word]
Forum: Mailmerge April 16th, 2010, 11:02 PM Posted to microsoft.public.word.mailmerge.fields
Replies: 11
Views: 578
Posted By macropod[_2_]
How to fill a word table with merge fields.

Hi ibmm,

For instructions on how to install & run a macro, see: http://www.gmayor.com/installing_macro.htm

--
Cheers
macropod
[Microsoft MVP - Word]
Forum: Mailmerge April 15th, 2010, 11:32 PM Posted to microsoft.public.word.mailmerge.fields
Replies: 2
Views: 327
Posted By macropod[_2_]
Mail merge to directory does not reset numbering in document

Hi Millieac,

If the records are in groups of 5, you could use a formula field coded as:
{=MOD({SEQ Counter},5)+1}
To output this as plain text, simply code the field as:
{QUOTE{=MOD({SEQ...
Forum: Worksheet Functions April 15th, 2010, 08:30 AM Posted to microsoft.public.excel.worksheet.functions
Replies: 2
Views: 108
Posted By macropod[_2_]
How do I recover a forgotten password?

Think carefully.

--
Cheers
macropod
[Microsoft MVP - Word]


"Zmont" wrote in message ...
Forum: General Discussion April 15th, 2010, 08:29 AM Posted to microsoft.public.word.docmanagement
Replies: 6
Views: 144
Posted By macropod[_2_]
^p means carriage return

Hi DeanH,

I know what you mean - they're probably part of the same group that hard-formats everything in sight, totally oblivious to the
underlying Styles (but mostly they just use 'Normal') and...
Forum: Page Layout April 15th, 2010, 08:11 AM Posted to microsoft.public.word.pagelayout
Replies: 4
Views: 625
Posted By macropod[_2_]
Is there a way to lock the margins in Word?

Hi Suzanne,

True. I suppose one could use a macro that taps into the DocumentBeforePrint event to force the page setup back to what it's
supposed to be. That'd fix 'em.

--...
Forum: Tables April 15th, 2010, 06:17 AM Posted to microsoft.public.word.tables
Replies: 1
Views: 326
Posted By macropod[_2_]
tables excel dans word 2007

bonjour hicham hassan,

mais ça ne marche pas comme je voulais
Expliquez svp !

Vous le trouverez probablement plus facile d'obtenir le conseil si vous posez votre question dans un forum de...
Forum: Tables April 15th, 2010, 06:11 AM Posted to microsoft.public.word.tables
Replies: 1
Views: 356
Posted By macropod[_2_]
can i add tool tips to column headers in a table

Hi Docubabe,

If you bookmark each column heading, you can select the heading then insert a hyperlink to it. The hyperlinking process allows you
to specify a 'Screen Tip' that displays when the user...
Forum: Tables April 15th, 2010, 05:24 AM Posted to microsoft.public.word.tables
Replies: 2
Views: 307
Posted By macropod[_2_]
Optimizing this formula?

Hi VcDeveloper,

Word's cell addressing doesn't directly support relative references. There is a workaround, however. To see how to do this and a
wide range of calculations in Word, check out my...
Forum: General Discussion April 15th, 2010, 02:26 AM Posted to microsoft.public.word.docmanagement
Replies: 2
Views: 129
Posted By macropod[_2_]
Field Code WOn't Perform

Hi Mike,

The whole point of using a MACROBUTTON field this way is that, as soon as you start typing in it, the field gets deleted. If that's
not what you want, perhaps you need to attach a macro to...
Forum: General Discussion April 15th, 2010, 02:21 AM Posted to microsoft.public.word.docmanagement
Replies: 2
Views: 131
Posted By macropod[_2_]
Need help with a formula

Hi Mike,

It's not possible to test cells containing text with field coding and cell references. You would need to bookmark each string (not
the whole cell) for the test. Even then, the ability to...
Showing results 1 to 25 of 100

 
Forum Jump

All times are GMT +1. The time now is 10:30 PM.


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