Deleting Text Sections

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Scott - 02 Oct 2007 20:26 GMT

Hi,

I have some automation for some documents interfacing with our application
and using VBA to invoke and do a mail merge with data produced in a text
file. I am looking for a good way to be able to show/not show or delete a
block of text/table based on values in the Mail Merge.

I am very much a beginner with VBA in Word and inherited this. Can anyone
help?

Also, does anyone have any good basic VBA mail merge tutorials?

Thanks,

Scott

Reply to this Message

Doug Robbins - Word MVP - 03 Oct 2007 07:33 GMT

While, you may be using VBA to invoke the mailmerge, it is probably not the
thing to be using for showing or not showing part of the text. That is
probably best done using a Word If...then...Else field construction that
tests for the value in the data source and either inserts, or does not
insert the text depending upon that value.

I am not quite sure what you mean by VBA Mail Merge Tutorials, but take a
look at the following:

"Mail Merge to E-mail with Attachments" at

http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm

and other articles on that site, and at "Duplex Merge Data for Postcards"
and other items on fellow MVP Graham Mayor's website at:

http://www.gmayor.com/duplex_merge_data.htm

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Hi,
>
[quoted text clipped - 11 lines]
>
> Scott

Reply to this Message