Increment Letter

[ashish mehra]

Hi Excel Experts,

Requirement: In my organization, there is a request from HR wherein they want to make Increment Letter.

Employees data will be available in excel file & all blanks in Increment Letter format will be filled automatically.

Thanks in advance!

Regards,
AM

 

[Debraj]

Hi Asish,

Did you tried Mail-Merge option in Word..!!

http://www.docs.is.ed.ac.uk/skills/documents/3468/3468.pdf

 

[VDS]

Hai Ashish,

Insert the data into MS word and try with mail merge. Even the formatting like bold, font size, etc becomes excellent.


VDS

 

[ashish mehra]

Yes Deb I tried Mail Merge. I tried to record & make a Macro in Word but this method is not working.

I believe I have to adopt another method in which Excel data can be copied to Word file.

Can somebody let me know if I can start recording my macro from Excel & then Copy data to Word file or so.

Let me know if anyone can help!

Regards,
AM

 

[VDS]

@Dear Ashish,

In fact macro is not even required. You can just copy+paste through OLE. Select the entire records. Copy, Press Alt + TAB paste into a new word file. Just Link it and use.


VDS

 

[ashish mehra]

Sounds great. Lemme try.
OLE?????

 

[VDS]

@Ashish,

OLE is the Object Linking and Embedding through which you can copy paste any of the text, doc etc from one application to another application in clip box. This forum provides all assistance in Excel only. So try yourselves and revert.


VDS

 

[ashish mehra]

Thanks DEB & VDS

Task completed.

Regards,
AM

 

[VDS]

@ Ashish,

Glad to solve it. All the best

VDS