Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel to word help
Hi, I have written a small macro that pulls data from excel to populat a letter with data in word (eg name, address, and some selecte paragraphs). here is an example of my code: visual basi code:--------------------------------------------------------------------------------wordarra = Array(addressline1, addressline2, addressline3, addressline4 postcode, Policynumber, Yourref, ourref, date, salutation, para1 para2, para3, para4, signed, position) wrd.Activedocument.Fields(1).Select With wrd.Selection .InsertAfter Text:=Addressee End With For wrdroutine = 0 To 15 wrd.Selection.NextField.Select With wrd.Selection .InsertAfter Text:=wordarray(wrdroutine) End With Next End -------------------------------------------------------------------------------- My problem is, sometimes para1 may not be applicable, and the same fo the rest of the paragraphs. So I could have a letter that will hav para2, para3 & para5. This will leave blank spaces were para1 & para are. Is there a way so that if para = "" (in this case para1 & para4 then it will delete that line where that are supposed to be input an the one below to bring the text up so there will not be 3 blank line between the next paragraph entere don the letter? I hope this makes sense! many thank -- rocket061 ----------------------------------------------------------------------- rocket0612's Profile: http://www.excelforum.com/member.php...fo&userid=1949 View this thread: http://www.excelforum.com/showthread.php?threadid=48342 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need Excel count of 1 word if found in multi-word cells of column | Excel Worksheet Functions | |||
Excel 7, paste linked to word becomes black when word pdf'd | Excel Discussion (Misc queries) | |||
Copy from Word to Excel, and retain indent, plus word wrap | Excel Discussion (Misc queries) | |||
Print labels by using Excel data in a Word mail into word | Excel Discussion (Misc queries) | |||
Printing Word Document using Excel Programming hangs Word | Excel Programming |