Andrea has attended:
Excel Introduction course
Transfering excel data to word
How do I get excel name & addresses to print out on word document.
RE: transfering excel data to word
Hi Andrea
Thank you for your question and welcome to the forum.
If you are transferring a single address from Excel into a Word document, this can be done by copying and pasting from Excel into Word.
To do this:
1. Select the name and address in Excel, and copy.
2. In the Word document, paste the name and address. A little smart tag with a clipboard icon on it will appear at the bottom right of what you have pasted.
3. Click on the Smart Tag and select the Keep Text Only option. This will remove the Excel data from the table format that it is pasted in to begin with.
If you are looking to transfer addresses for a mass mailing, then use the Mail Merge wizard in Word (Tools - Letters and Mailings - Mail Merge).
Kind regards
Amanda