- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
I understand the you excel file has data that is stored column wise. Well you can first convert the column wise data to row wise data and then import it to you word.
To convert the column wise data to row wise data. 1.Select the data in your worksheet. 2.Right Click -> Copy 3.Create a blank worksheet. 4.Goto Edit - > Paste Special 5.Check the Transponse Option 6.Press OK.
Now you have converted your column wise data to row wise data and now u can import it to your word and print mailing labels
You will need to open the file using ADO and read the data into a recordset. Then loop through the rows and write them to a text file and use concatenation to format the rows in the text file as needed (CSV, tab delimited, whatever you need). Remember to add a vbCrLf after each row!
You would have to combine the use of 2 functions. The Address and Match funbctions.
Lets say the number you want the address of is located in cell F1 and you have 2 columns of numbers. One colum in Column A and the other in column B. I will give you 2 formulas. The 1st one will return just the row number. The 2nd one will return the cell address.
Option 1: Lets say you just want to know the row reference of the number in cell F1. Place this formula in cell D1. =MATCH(F1,A1:A20)
If you have another column ytou want the row number of, place the formula in lets say cell D2 and change the column references from 'A' to 'B'.
Option 2: If you want the cell reference, place this formula in cell D1 and D2 instead of the firt formula.
And just like the first option, for the 2nd column, put the formula in D2 and change the column reference 'A' to 'B'.
I had the same the problem. The cause was a corrupted encryption code. That is why only worked the keys that don't require encryption. 1) Install the Logitech software and restart. 2) The software will tell you to press CTRL-ALT-F12. This procedure resets the keyboard encryption and tells you to enter a new code. 3) If you already had the software installed simply press CTRL-ALT-F12 and follow the above procedure.