Excel cell value with space between paragraphs with excel to word bookmark

[molesy01]

Hi
I have a userform in excel that copies text from a cell and puts it within a bookmark in a word template. I have created code which works however the issue i have is that i require more than 1 cell value to populate into a single bookmark with a space between the paragraphs. Hope someone can help. Thanks

sub ExportButton(control As IRibbonControl)

Dim objWord As Object
Dim ws As Worksheet
Set ws = ThisWorkbook.Sheets("Testing")
Set objWord = CreateObject("Word.Application")
objWord.Visible = True
objWord.Activate
objWord.Documents.Open "\\Desktop\Testing.dotm"
With objWord.ActiveDocument
.Bookmarks("RPD").Range.Text = ws.Range("E10").Value
.Bookmarks("RPD").Range.Text = ws.Range("E12").Value
.Bookmarks("RPD").Range.Text = ws.Range("E14").Value

End With

Set objWord = Nothing

End Sub

 

[molesy01]

sorry to say same error.

 

[molesy01]

Would i need to have all of the sheets completed for it to work without the error, I only have Section A,B,C with text in column E, ?

 

[NdNoviceHlp]

Shouldn't error on that line of code but it would eventually error. If the code was successful, then some documents would have been produced. Just thought of something. If the code errors, you need to go to the task manger, select Microsoft Word and End Process before re-trialing the code. Dave

 

[molesy01]

Shouldn't error on that line of code but it would eventually error. If the code was successful, then some documents would have been produced. Just thought of something. If the code errors, you need to go to the task manger, select Microsoft Word and End Process before re-trialing the code. Dave

Hi Dave yes I always delete the last doc in task manager. I will put a doc and wb together and send over to your email to see if it can be done. Thanks

 

[molesy01]

Hi Dave. Any luck with the files I sent. Thanks