Create letter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I have a data in excel, I want to draft a letter by using table which I have
created in excel.
Can I create a button in excel, and if I press that button the data which I
created in excel should automatically get copied in one particular word file,
and should draft a letter.
Is it possible in VBA and how. Pls. help me


Regards,
Vishu
 
Vishu -

It sounds like you want to "mail merge". Look that up in Word Help, and it
will step you through the process.

Carole O
 
Hi corole,
I dont want do in mail merge. Because mail merge is only for fixed cells in
excel.
I have data in excel will vary from time to time.
Data are in cell A2:F27 it may change after some time to A2:Z250.
I want to do in VBA. if i press button i should get a letter for excel data.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do i create macro for export excel data to word in to letters 1
How to type each letter of the alphabet automatically in a specific color in Word? 0
Help to create a macro 2
Excel VBA - Problem with Closing Print Preview 0
mail merge-word file automatically closing 3
Excel Convert word into numbers and back 4
HOW TO CREATE A LETTER TEMPLATE IN EXCEL? 1
changing capslock letters into normal letters 4

Back
Top