Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
mailmerge to a word document from email addresses in a single cell of an excel sheet
hi all,
i have an excel worksheet which has some data a row. the last column in that row is for email addresses. i am entering multiple email addresses in a single cell. when i click one of the email addresses in that cell, it should transfer all the email addresses into a word mailmerge document which i am printing for multiple users. But when i click, only the first email address comes into the field in the Word Mailmerge document. Please note that I dont want to place each email address in a single cell in that last column as one row needs to have multiple email addresses. I also donot want to merge each cell in a column with the one below it, inorder to have the last column showing each address in each cell one below the other. PLEASE HELP ASAP |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
mailmerge to a word document from email addresses in a single cell of an excel sheet
Hi ....,
I think your problem is that you don't have titles at the top of each column. For step by step instructions to do mail merge to print labels see http://www.mvps.org/dmcritchie/excel/mailmerg.htm Also make sure that your worksheet is at the first worksheet tab, drag it there if it is not. If not labels the letters, and envelopes are much the same, but you can refer to one of links on the above page to a Microsoft Word oriented presentation. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "junoon" wrote in message ups.com... hi all, i have an excel worksheet which has some data a row. the last column in that row is for email addresses. i am entering multiple email addresses in a single cell. when i click one of the email addresses in that cell, it should transfer all the email addresses into a word mailmerge document which i am printing for multiple users. But when i click, only the first email address comes into the field in the Word Mailmerge document. Please note that I dont want to place each email address in a single cell in that last column as one row needs to have multiple email addresses. I also donot want to merge each cell in a column with the one below it, inorder to have the last column showing each address in each cell one below the other. PLEASE HELP ASAP |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
mailmerge to a word document from email addresses in a single cell of an excel sheet
Hi David,
sorry, I guess i was not clear before. The Excel workbook has only 1 worksheet & i.e the worksheet which i am using to put data into fields on a word Mailmerge document. the excel sheet has been selected as the Data source. All the data are coming into the word document..no problems, except the email addresses, which i have entered (separated yb semi-colons) into a SINGLE CELL in the worksheet. Only the 1st email address appears in the field in the mailmerge document, not the others. I want to get all the email addresses to show in the field in word, whenever i click on an email address in the single cell of the worksheet. Rgds, Junoon |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
mailmerge to a word document from email addresses in a single cell of an excel sheet
You must have each field in a separate cells across the row.
Make a copy of the worksheet (remember must be the first worksheet tab). Use Data (menu), Text to columns to separate at semicolons - choose delimited in the first dialog - use semi-colon as the delimiter --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "junoon" wrote in message ups.com... Hi David, sorry, I guess i was not clear before. The Excel workbook has only 1 worksheet & i.e the worksheet which i am using to put data into fields on a word Mailmerge document. the excel sheet has been selected as the Data source. All the data are coming into the word document..no problems, except the email addresses, which i have entered (separated yb semi-colons) into a SINGLE CELL in the worksheet. Only the 1st email address appears in the field in the mailmerge document, not the others. I want to get all the email addresses to show in the field in word, whenever i click on an email address in the single cell of the worksheet. Rgds, Junoon |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I would like to extract email addresses from an Excel document | Excel Discussion (Misc queries) | |||
Excel 2003 - Putting an email/word document into a cell | Excel Discussion (Misc queries) | |||
can I insert/embed a word document in a single excel cell? | Excel Discussion (Misc queries) | |||
Saving email addresses from excel document | Excel Discussion (Misc queries) | |||
Is there a way to insert a word document into a single excel cell | Excel Programming |