Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
rroswell86 rroswell86 is offline
external usenet poster
 
Posts: 11
Default merge from excel and formatting

I have fields in my excel document that include double spacing, etc. When I
export to Word, I loose that formatting. Can I fix this? (I asked this in
the Excel section, but realized it may be a word function)

Thanks!

  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default merge from excel and formatting

Can you spell out exactly what you mean by "double spacing" and how you
applied it?

Peter Jamieson

http://tips.pjmsn.me.uk

On 30/03/2010 19:37, rroswell86 wrote:
I have fields in my excel document that include double spacing, etc. When I
export to Word, I loose that formatting. Can I fix this? (I asked this in
the Excel section, but realized it may be a word function)

Thanks!

  #3   Report Post  
Posted to microsoft.public.word.docmanagement
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default merge from excel and formatting

Can you spell out exactly what you mean by "double spacing" and how you
applied it?

Peter Jamieson

http://tips.pjmsn.me.uk

On 30/03/2010 19:37, rroswell86 wrote:
I have fields in my excel document that include double spacing, etc. When I
export to Word, I loose that formatting. Can I fix this? (I asked this in
the Excel section, but realized it may be a word function)

Thanks!

  #4   Report Post  
Posted to microsoft.public.word.docmanagement
rroswell86 rroswell86 is offline
external usenet poster
 
Posts: 11
Default merge from excel and formatting

Data consists of paragraphs seperated by blank lines, as below:

xxxxxxxxxx
xxxxxxxx

xxxxxxxxx
xxxxxxx

all in one cell.

"Peter Jamieson" wrote:

Can you spell out exactly what you mean by "double spacing" and how you
applied it?

Peter Jamieson

http://tips.pjmsn.me.uk

On 30/03/2010 19:37, rroswell86 wrote:
I have fields in my excel document that include double spacing, etc. When I
export to Word, I loose that formatting. Can I fix this? (I asked this in
the Excel section, but realized it may be a word function)

Thanks!

.

  #5   Report Post  
Posted to microsoft.public.word.docmanagement
rroswell86 rroswell86 is offline
external usenet poster
 
Posts: 11
Default merge from excel and formatting

Data consists of paragraphs seperated by blank lines, as below:

xxxxxxxxxx
xxxxxxxx

xxxxxxxxx
xxxxxxx

all in one cell.

"Peter Jamieson" wrote:

Can you spell out exactly what you mean by "double spacing" and how you
applied it?

Peter Jamieson

http://tips.pjmsn.me.uk

On 30/03/2010 19:37, rroswell86 wrote:
I have fields in my excel document that include double spacing, etc. When I
export to Word, I loose that formatting. Can I fix this? (I asked this in
the Excel section, but realized it may be a word function)

Thanks!

.



  #6   Report Post  
Posted to microsoft.public.word.docmanagement
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default merge from excel and formatting

Hi rroswell86,

In a mailmerge, you get the data, not the formatting. Line feeds in an Excel cell are just that and do not represent paragraphs in
Word - even if you copy the cell and paste it into Word manually, then convert the resulting cell from a table to text.

--
Cheers
macropod
[Microsoft MVP - Word]


"rroswell86" wrote in message ...
Data consists of paragraphs seperated by blank lines, as below:

xxxxxxxxxx
xxxxxxxx

xxxxxxxxx
xxxxxxx

all in one cell.

"Peter Jamieson" wrote:

Can you spell out exactly what you mean by "double spacing" and how you
applied it?

Peter Jamieson

http://tips.pjmsn.me.uk

On 30/03/2010 19:37, rroswell86 wrote:
I have fields in my excel document that include double spacing, etc. When I
export to Word, I loose that formatting. Can I fix this? (I asked this in
the Excel section, but realized it may be a word function)

Thanks!

.


  #7   Report Post  
Posted to microsoft.public.word.docmanagement
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default merge from excel and formatting

Hi rroswell86,

In a mailmerge, you get the data, not the formatting. Line feeds in an Excel cell are just that and do not represent paragraphs in
Word - even if you copy the cell and paste it into Word manually, then convert the resulting cell from a table to text.

--
Cheers
macropod
[Microsoft MVP - Word]


"rroswell86" wrote in message ...
Data consists of paragraphs seperated by blank lines, as below:

xxxxxxxxxx
xxxxxxxx

xxxxxxxxx
xxxxxxx

all in one cell.

"Peter Jamieson" wrote:

Can you spell out exactly what you mean by "double spacing" and how you
applied it?

Peter Jamieson

http://tips.pjmsn.me.uk

On 30/03/2010 19:37, rroswell86 wrote:
I have fields in my excel document that include double spacing, etc. When I
export to Word, I loose that formatting. Can I fix this? (I asked this in
the Excel section, but realized it may be a word function)

Thanks!

.


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
Catalog merge from Excel; $ formatting srpd Mailmerge 0 February 9th 09 11:06 PM
Catalog merge from Excel; $ formatting srpd Mailmerge 0 February 9th 09 08:01 PM
Catalog merge from Excel; $ formatting srpd Mailmerge 1 February 9th 09 07:43 PM
Merge from excel loses formatting Craig Mailmerge 3 February 24th 06 04:21 PM
Excel Formatting in Mail Merge dpahlow@nwtc Mailmerge 1 July 29th 05 06:25 PM


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