Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating an email list from a data base
I am new to concantenate, but I think I should be able to use it to take
emails from a column in Excel and create a string I can paste into Outlook to email a group. I can't seem to get the ; in the right spot -- I get a space before it. Also is there a way to copy the formula down so I don't have to write it for every entry? Thanks, |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating an email list from a data base
Let me give you better details, I think you are on the right track to helping
me, but this did not work exactly as I wanted. My Scenario: Col. A Rows 2-22 I have email addresses - In essence I want to put these in one cell with the ";" symbol between so I can then just copy into the TO box in Outlook. A text string of sorts I guess. Thanks, SLSTAR "RyanR" wrote: A little more background would be more helpful, such as a copy of the formula you are using, but there are only 2 reasons you are getting the space: 1 - you have a space in the formula 2 - you have trailing spaces in the e-mail address. let's assume the following data set: A B 1 Address Long string 2 3 4 The formula in B3 would then be: =trim(B2)&";"&trim(A3) The trim function will remove any leading and trailing spaces, and note there are no spaces in my ";" Note that Excel no longer requires the concatenate function to be explicitly called, you can use ampersands '&' and excel will assume the concatenate function. Part 2, to fill down a formula, hover your mouse over the bottom-right corner of the cell to be copied, double-click, it will fill down the formula till it reaches a blank cell to it's left. You can also use the standard copy/paste method, incorporating paste-special if you only want to copy the formula without any formatting. -- Cheers, RyanR --- pls click yes if I''ve helped you --- "SLSTAR" wrote: I am new to concantenate, but I think I should be able to use it to take emails from a column in Excel and create a string I can paste into Outlook to email a group. I can't seem to get the ; in the right spot -- I get a space before it. Also is there a way to copy the formula down so I don't have to write it for every entry? Thanks, |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating an email list from a data base
What I've given you will work.
You need to copy the formula down for _every_ row you need to include, so copy from B2 to B22. The formula takes the value above it, and adds a ";" and the contents of the e-mail next to it. The very last row will contain the complete string (assuming the total width does not violate excel limitations [32,767 characters in xl2007]) -- Cheers, RyanR --- pls click yes if I''ve helped you --- "SLSTAR" wrote: Let me give you better details, I think you are on the right track to helping me, but this did not work exactly as I wanted. My Scenario: Col. A Rows 2-22 I have email addresses - In essence I want to put these in one cell with the ";" symbol between so I can then just copy into the TO box in Outlook. A text string of sorts I guess. Thanks, SLSTAR "RyanR" wrote: A little more background would be more helpful, such as a copy of the formula you are using, but there are only 2 reasons you are getting the space: 1 - you have a space in the formula 2 - you have trailing spaces in the e-mail address. let's assume the following data set: A B 1 Address Long string 2 3 4 The formula in B3 would then be: =trim(B2)&";"&trim(A3) The trim function will remove any leading and trailing spaces, and note there are no spaces in my ";" Note that Excel no longer requires the concatenate function to be explicitly called, you can use ampersands '&' and excel will assume the concatenate function. Part 2, to fill down a formula, hover your mouse over the bottom-right corner of the cell to be copied, double-click, it will fill down the formula till it reaches a blank cell to it's left. You can also use the standard copy/paste method, incorporating paste-special if you only want to copy the formula without any formatting. -- Cheers, RyanR --- pls click yes if I''ve helped you --- "SLSTAR" wrote: I am new to concantenate, but I think I should be able to use it to take emails from a column in Excel and create a string I can paste into Outlook to email a group. I can't seem to get the ; in the right spot -- I get a space before it. Also is there a way to copy the formula down so I don't have to write it for every entry? Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Searching long data base list. | Excel Worksheet Functions | |||
Creating graph (floating columns with top and base depth values) | Excel Discussion (Misc queries) | |||
Help: Creating Data List and value | Excel Worksheet Functions | |||
How to stop creating an new email msg when I click on a data cell | Excel Worksheet Functions | |||
I want to link my order form with my data base list | Excel Discussion (Misc queries) |