Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Create letter
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 |
#2
|
|||
|
|||
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 "vishu" wrote: 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 |
#3
|
|||
|
|||
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. "Carole O" wrote: 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 "vishu" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you create a complicated pivot table graph? | Charts and Charting in Excel | |||
Can't create dynamic charts | Charts and Charting in Excel | |||
Template in Excel | New Users to Excel | |||
Have A Letter Reference A Name For An Intoduction | New Users to Excel | |||
Replace Letter "E" with Letter "C" for 200 Different Sums in a Col | Excel Worksheet Functions |