Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
Brent E Brent E is offline
external usenet poster
 
Posts: 4
Default Merging Data From Excel Into Different Formatted Fields In Word

Good morning,

Being vaguely familiar w/ the mail merge function and from reading through
some of the posts on the mail merge subject, I know this is possible but need
somebody to walke me throught the steps.

Goal: I will put together a Word document that I would like to populate
sections from data in Excel

I have some questions regarding this:

1. Does the mail merge feature work in Text boxes also or how do you create
a "field" to use w/ a mail merge?

2. Does the formatting of a field or text box matter in the merge process?
(E.g. if I have a name field that is set to a specific and large font type,
but then an address field at different font size or color, does this limit
the merge abililty? And will the properties of the data moving over keep the
formatting properties of the cell in Excel or take the field properties from
Word?)

3. What are the steps to create the mail merge once I have the "fields" set
the way I want them in Word?

I appreciate your assistance. Thanks in Advance.

Cordailly,

  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
Default Merging Data From Excel Into Different Formatted Fields In Word

Start with these articles:

How to create a Mail merge
http://word.mvps.org/FAQs/MailMerge/...AMailMerge.htm

Creating a mail merge Data Source
http://word.mvps.org/FAQs/MailMerge/...DataSource.htm

Express mail merges in Word 2002 and 2003
http://sbarnhill.mvps.org/WordFAQs/E...MailMerges.htm

These give you the basic principles. Come back with questions after you've
read them.
--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Brent E" wrote in message
...
Good morning,

Being vaguely familiar w/ the mail merge function and from reading through
some of the posts on the mail merge subject, I know this is possible but

need
somebody to walke me throught the steps.

Goal: I will put together a Word document that I would like to populate
sections from data in Excel

I have some questions regarding this:

1. Does the mail merge feature work in Text boxes also or how do you

create
a "field" to use w/ a mail merge?

2. Does the formatting of a field or text box matter in the merge process?
(E.g. if I have a name field that is set to a specific and large font

type,
but then an address field at different font size or color, does this limit
the merge abililty? And will the properties of the data moving over keep

the
formatting properties of the cell in Excel or take the field properties

from
Word?)

3. What are the steps to create the mail merge once I have the "fields"

set
the way I want them in Word?

I appreciate your assistance. Thanks in Advance.

Cordailly,


  #3   Report Post  
Posted to microsoft.public.word.docmanagement
Brent E Brent E is offline
external usenet poster
 
Posts: 4
Default Merging Data From Excel Into Different Formatted Fields In Wor

Good day Suzanne,

Thanks for the links to the articles. Looks great. I've been looking at them
as time permits. I will continue to look at them as I am able. The tutorials
look very helpful. I really appreciate the thorough info. I'll let you know
if I have further questions. Thanks, have a great weekend.


"Suzanne S. Barnhill" wrote:

Start with these articles:

How to create a Mail merge
http://word.mvps.org/FAQs/MailMerge/...AMailMerge.htm

Creating a mail merge Data Source
http://word.mvps.org/FAQs/MailMerge/...DataSource.htm

Express mail merges in Word 2002 and 2003
http://sbarnhill.mvps.org/WordFAQs/E...MailMerges.htm

These give you the basic principles. Come back with questions after you've
read them.
--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Brent E" wrote in message
...
Good morning,

Being vaguely familiar w/ the mail merge function and from reading through
some of the posts on the mail merge subject, I know this is possible but

need
somebody to walke me throught the steps.

Goal: I will put together a Word document that I would like to populate
sections from data in Excel

I have some questions regarding this:

1. Does the mail merge feature work in Text boxes also or how do you

create
a "field" to use w/ a mail merge?

2. Does the formatting of a field or text box matter in the merge process?
(E.g. if I have a name field that is set to a specific and large font

type,
but then an address field at different font size or color, does this limit
the merge abililty? And will the properties of the data moving over keep

the
formatting properties of the cell in Excel or take the field properties

from
Word?)

3. What are the steps to create the mail merge once I have the "fields"

set
the way I want them in Word?

I appreciate your assistance. Thanks in Advance.

Cordailly,



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
Can't get Word 2003 to keep data file with mail merge main documen Yourcareercoach Mailmerge 9 August 10th 06 12:19 PM
Word & WordPerfect MrsMac Microsoft Word Help 5 June 10th 06 03:14 AM
WP merge file to Word sstires Tables 4 February 14th 06 06:26 PM
Difficulty pasting Excel data into Word table only in XP versions Digitonomy Tables 0 February 28th 05 12:33 AM
Word Field Codes in Excel data file mranz Mailmerge 7 December 11th 04 09:02 AM


All times are GMT +1. The time now is 08:41 AM.

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"