![]() |
#10
|
|||
|
|||
![]()
That helped, but what was causing the merging problem is some of the empty lines separating each adressee aren't actually empty. About 450 of these lines contained 1 or more spaces. After applying your last command, it left them with 1 space, which still caused merging of addresses into a single cell. What's needed in this case is to make the separating blank line with 1 space into an actual blank line with no single space. Without wildcards, I did this:
Find = ^p ^p Replace = ^p^p And that did the trick! Everything worked as intended. Mr. Edstein, you are my new hero. That was my 47th b-day present (it's still Nov. 12 here in Brazil ![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Insert specific picture and add specific Text to it | Syasthe | Word VBA | 1 | 11-02-2017 02:08 AM |
Have a very specific requirement | ggoffice000 | Excel Programming | 2 | 02-03-2017 03:47 PM |
Print attachment when it arrive in specific folder with specific subject | visha_1984 | Outlook | 1 | 01-30-2013 10:42 AM |
![]() |
dextrousdave | Word | 1 | 01-16-2012 09:10 PM |
![]() |
DivideByZer0 | Excel | 3 | 11-10-2009 05:58 PM |