I have the following HTML code that I would like to remove if one of the criteria is blank. The following part below were it shows "yes'>10</span>"...if there is nothing there I would like to remove it.
style='mso-no-proof:
yes'>10</span></span><!--[if supportFields]><span...
Thanks for you assistance but merging direct to e-mail will not allow for the custom subject line per recipient and custom attachments.
When the .Body is changed to .HTMLBody nothing happens. If the whole document is not converted to HTML the file will still be sent as text.
Another issue that I hope someone can help. The whole purpose is to send out a Mail Merge in HTML format while customizing the Subject Line, CC and adding attachments. So once I converted the file to "Edit Individual Document", I then used the above VB code to removed all row and then I use the...
Thank TonyJollans and Andrzejek for you response. As I was waiting on a response I manage to find another VB code that works. I provided below in case others are interested:
Sub DelBlankRows()
Dim tblT As Table
Dim cllC As Cell
Dim blnEmpty As Boolean
Dim n As Integer
On Error GoTo ErrHnd...
In order to understand my questions let me give you some background detail that should help.
I've created a Mail Merge in Microsoft Word and converted it to Edit Individual Documents(this puts all records on one file separated by page break).
Below is a sample of what I'm using:
Dear James...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.