NishanthSruju
New Member
- Joined
- Aug 29, 2022
- Messages
- 1
- Office Version
- 365
Im trying to copy address of companies from excel (office address) and paste it in word. I have used alt+enter in address for each line within cell for location,city, street etc. My macro is able to paste information but it is creating addtional line spacing while pasting information. Can you please help. Apart from above, for few words while copying and pasting data it is bolding the text which I do not want. Can you please help?
With objWord.ActiveDocument
.Bookmarks("FRlegalentity").Range.Text = ws.Cells(i, 4).Value
.Bookmarks("OffFRPRDate").Range.Text = Range("DA1").Value
.Bookmarks("FRoffadd").Range.Text = ws.Cells(i, 89).Text
End with
With objWord.ActiveDocument
.Bookmarks("FRlegalentity").Range.Text = ws.Cells(i, 4).Value
.Bookmarks("OffFRPRDate").Range.Text = Range("DA1").Value
.Bookmarks("FRoffadd").Range.Text = ws.Cells(i, 89).Text
End with