Deleting 3 lines of code from a word document using VB.NET

Question

1.00/5 (1 vote)

See more:

Hi,

I have a word document which has a merge field and 3 lines of address after that. For example,

<<SAMPLEMERGEFIELD>>
ADDRESS LINE 1
ADDRESS LINE 2
STATE

Through my vb.net application, I am replacing merge field with the value retrieved from the database. This functionality is working properly.
If value retrieved from database is NULL, then I would like to delete the <<SAMPLEMERGEFIELD>> as well as the 3 lines after that.
Do you have code to accomplish this?

Posted 23-Jun-14 7:36am

smehta.er

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2014-06-23T09:10:00

Solution 1

I really do believe there is an option to skip NULL data.

Have a look here:
Mail Merge: Part I[^]
Mail Merge: Part II[^]

If you still want to delete some portion of data, you need to know there is no "lines", there are paragraphs[^].

Posted 23-Jun-14 9:10am

Maciej Los

Comments

smehta.er 23-Jun-14 17:22pm

Thanks for the reply. The address is hardcoded in the doc. Are you saying that I would have to find this address in the word document and then delete it?

Maciej Los 23-Jun-14 17:31pm

If address is hard-coded, yeah! Follow this link: http://msdn.microsoft.com/en-us/library/f1f367bx.aspx

smehta.er 25-Jun-14 14:29pm

Address is present at multiple places in the same doc. If I find and replace that with blank, there is a chance that address will be replaced at multiple places with blank. As of now, I found a workaround to delete the address. This address takes around 55 characters after the merge field. I am trying to delete 55 characters once I find the merge field in the doc and observe that the value retrieved from the database is Null or empty. Here is the sample code:

For Each wrdrange In wrdDoc.StoryRanges
With wrdrange.Find
.Forward = True
.ClearFormatting()
.Execute(FindText:=SAMPLEMERGEFIELD)
End With
If UCase(wrdrange.Text) = UCase(Trim(SAMPLEMERGEFIELD)) Then
If Trim(varsamplemergefield) = String.Empty Then
wrdrange.Delete(Unit:=Word.WdUnits.wdCharacter, Count:=55)
Else
wrdrange.Text = varsamplemergefield
End If
End If

Next wrdrange

I am looking for a solution to delete 3 lines rather than deleting 55 characters. I tried changing the units to wdLine but it does not work. Do you have any idea?