Excel --> Word Automatic fill ?

[audrey]

Hello

I have a very basic excel sheet that needs to automatically fill a word document.

e.g excel Column A --> Name of the Person

Word document Name field.

I need to fill approx 70-100 word sheet like that instead of copy and pasting information.


Thank you in advance for any advices

Audrey

 

[Andrew Poulsom]

It sounds like you need Mail Merge:

http://www.meadinkent.co.uk/mail-merge1.htm

http://office.microsoft.com/en-us/w...e-a-walk-through-the-process-HA001034920.aspx

 

[audrey]

Thanks you for the prompt response Andrew...

I am also wondering whether it replicates/creates word documents ?

 

[Andrew Poulsom]

Yes, a new document are created.

 

[audrey]

last question, I am using excel 2007, and I have installed pdf maker. I want to save those word sheet seperately....any body knows how to ?

http://www.microsoft.com/downloads/...11-3E7E-4AE6-B059-A2E79ED87041&displaylang=en

 

[audrey]

I have now a pdf document that consists of 70 letters, how can I seperate and save them one ?

 

[Andrew Poulsom]

Maybe this will help you:

http://word.tips.net/Pages/T001326_Creating_Files_with_Mail_Merge.html

 

[audrey]

thank you once again

last question,is there way to rename the sheets the way I want it ?

Sub Splitter()
Selection.EndKey Unit:=wdStory
numlets = Selection.Information(wdActiveEndSectionNumber)
If numlets > 1 Then numlets = numlets - 1
Selection.HomeKey Unit:=wdStory
BaseName = "c:\"
For Counter = 1 To numlets
DocName = "Name of the Person" & Right("000" & LTrim(Str(Counter)), 3)
ActiveDocument.Sections.First.Range.Cut
Documents.Add
Selection.Paste
Selection.MoveLeft Unit:=wdCharacter, Count:=1
Selection.Delete Unit:=wdCharacter, Count:=1
ActiveDocument.SaveAs FileName:=DocName
ActiveWindow.Close
Next Counter
End Sub

 

[audrey]

by the way name of the person written is inside the sheet

 

[audrey]

Currently the macro is naming sheets as Base Name 001 002 003 etc...

I was wondering if there is a way I name of the sheet can be the name after To: within the word document ?