View Single Post
  #4  
Old June 28th, 2004, 07:56 PM
Ann Scharpf
external usenet poster
 
Posts: n/a
Default Macro help please: Excel data to word doc

Oh man! What a lot of hassle to avoid using the proper
tool for the task! You have my sympathy.

And, yes, you can insert line feeds inside a cell. Just
press ALT-Enter to get a new line. Do it twice to insert
a blank space between paragraphs in the one-cell "letter."

Ann
-----Original Message-----
Ann...thanks for your reply.

I know how to do a mail merge in Word, the problem is

that I am catering to a very lazy, computer-illiterate
person here. Each of our clients has their own workbook
in Excel, which holds a number of sheets for different
purposes. I agree that the best way to write a letter is
in Word; however, the bulk of our tasks makes more sense
in Excel, and my boss would prefer everything together in
one place (have his cake and eat it too), or rather, one
excel workbook. Anyways, it is possible to do a letter in
Excel so I have done so and it's fine. The letter is
already formatted with opening/closing text in one large,
page-sized column (to enable text wrapping for the body of
the letter). The body of the letter (which they type
themselves) is placed in one single, page-sized, text-
wrapping cell. Another way to fix this problem would be
if they could hit enter to begin a new paragraph within
this cell, instead of automatically transferring to the
cell below. Is there a way to create spaces between
paragraphs within a single cell?

Otherwise, the file they work from is in an Excel

workbook, so they would prefer if there was a link within
the workbook that would open a blank word document with
the opening/closing text autmatically inserted from the
Excel workbook.

I know it's a lot to ask (or is it? maybe i'm just not

that bright! haha).

Thanks!