Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
Seth Schwarm Seth Schwarm is offline
external usenet poster
 
Posts: 1
Default Create formula using a merge field

I would like to create this formula in a Word document -

=Left(Trim({MERGEFIELD name}), 3)

'name' is the name of a merge field.
How do I accomplish this or is it possible?

Thanks much.
Seth

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...ocmanagemen t
  #2   Report Post  
Posted to microsoft.public.word.docmanagement
macropod macropod is offline
external usenet poster
 
Posts: 1,002
Default Create formula using a merge field

Hi Seth,

No can do with a field - Word fields don't support 'LEFT' or 'TRIM'
functions. You'll need to modify the source data, or use a macro in
conjunction with the mailmerge.

Cheers

--
macropod
[MVP - Microsoft Word]


"Seth Schwarm" wrote in message
...
I would like to create this formula in a Word document -

=Left(Trim({MERGEFIELD name}), 3)

'name' is the name of a merge field.
How do I accomplish this or is it possible?

Thanks much.
Seth

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow

this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.


http://www.microsoft.com/office/comm...ocmanagemen t


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 mail merge to EMAIL from MS Word AND add a pdf attachment Lily@Insight Mailmerge 24 January 15th 07 10:33 PM
Merge field control in Documents PhilD Mailmerge 1 May 17th 06 03:15 PM
merge letter with drop down form field Sarah Mailmerge 2 January 25th 06 12:33 AM
Merge field delimiter in insert field formula ? AlexT Mailmerge 3 November 24th 05 01:25 PM
Can you create a multi-layered merge where certain merge fields a. mileszat Mailmerge 3 January 18th 05 04:46 AM


All times are GMT +1. The time now is 07:56 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"