Hi, I've been trying for a few days now, modifying code from the internet, to find a clear way of importing Excel cell data into Word bookmarks. I only have a very superficial understanding of VBA and can't figure out how to make the two programs work seamlessly. The code I found helps me with the opening documents and things like that but I need something that helps me import scattered cells on a worksheet into a bookmarked template in Word. I don't want to use Mail Merge feature or Word macros. I need Excel to take care of everything, preferably keeping it clean and simple by performing the cell copy and bookmark replacing in one (ideally) or two lines of code per operation.
Could anyone offer their knowledge to help me solve this problem? It might be very simple but I can't make it work on my own.
Bookmarks