How to do Formatting Using Macros

macropod · #2 03-11-2013, 04:15 AM

Quote:

Originally Posted by anju16saini

Where there is no value for the particular field , my bookmark name is appearing ; whereas it should be blank.

So why does the name appear there at all? This is totally unnecessary.

Quote:

I have 2 values for a particular field . and my value is appearing in a single line with @@

Use the vba Replace function to replace @@ with vbCr or Chr(11) before updating the document.

PS: When posting code, please use formatted code and the code tags. They're on the 'Go Advanced' tab.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Help, may need macros!!	Jamtart	PowerPoint	5	08-06-2012 08:24 AM
Formatting with macros	WaltR	Word VBA	8	05-15-2012 06:28 PM
VBA macros	tays01s	Word VBA	6	08-03-2011 09:42 PM
Macros	Steveg	Word VBA	0	08-18-2010 04:04 PM
macros	trancetheory	Outlook	0	05-11-2010 09:31 AM