Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Sean Steele Sean Steele is offline
external usenet poster
 
Posts: 2
Default FULLNAME merge field: how do I get it to just show the first name, i.e. everything before the space and nothing after the space.

I have a mail merge template that only allows me to insert the
FULLNAME, but I want to be able to just pull the first name from that
field. Is there a way to tell Word to delete everything after the
space? So, the value that would normally be pulled into this field
would be "John Doe." I just want it to pull "John." Let me know if
there is anything I can do.

Thanks,
Sean

  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
macropod macropod is offline
external usenet poster
 
Posts: 1,002
Default FULLNAME merge field: how do I get it to just show the first name, i.e. everything before the space and nothing after the space.

Hi Sean,

Word's mailmerge can't manipulate the data that way - you'll need to change the data source.

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"Sean Steele" wrote in message ups.com...
I have a mail merge template that only allows me to insert the
FULLNAME, but I want to be able to just pull the first name from that
field. Is there a way to tell Word to delete everything after the
space? So, the value that would normally be pulled into this field
would be "John Doe." I just want it to pull "John." Let me know if
there is anything I can do.

Thanks,
Sean

  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
macropod macropod is offline
external usenet poster
 
Posts: 1,002
Default FULLNAME merge field: how do I get it to just show the first name, i.e. everything before the space and nothing after the space.


"+Bob+" wrote in message ...
On Sat, 29 Sep 2007 09:17:36 +1000, "macropod"
wrote:


Or, more directly - this is what happens when people who don't know
squat about designing data storage start storing data. No offense, but
there's a reason people get degrees in subjects like this.


Or maybe the OP just has a list of names, that was never intended to be used for mailmerges, and is trying to re-purpose it.

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------
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
too much space between lines in a list (single space for page setu 01anne Microsoft Word Help 2 April 25th 07 09:00 PM
Go from single space to double space lines on a WORD doc Arthur Microsoft Word Help 1 August 13th 06 08:09 PM
Can Mail Merge include a space at the beginning of a field? Joshua Mailmerge 5 April 13th 06 06:37 AM
Where are the "show white space" and "hide white space" buttons? Robin K Microsoft Word Help 2 June 22nd 05 11:10 PM
How do I add a space in a line if a merge field is blank? S Cocke Mailmerge 4 February 11th 05 11:13 PM


All times are GMT +1. The time now is 06:01 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"