Need help editing a large Word Doc for email addresses!

Answers

• 

  

  0

  Sign in to vote

  See “Convert Labels into Mail Merge Data File” on fellow MVP Graham Mayor’s website at:

  http://www.gmayor.com/convert_labels_into_mail_merge.htm
   -- Hope this helps.

  Doug Robbins - Word MVP,
  dkr[atsymbol]mvps[dot]org
  Posted via the Community Bridge

  "DocMHale" wrote in message news:7496fb38-ac61-4397-9125-688832fab2d8@communitybridge.codeplex.com...

  I have a 2700 page file that contains names, addresses, and email addresses and I want to extract the names with the correct email addresses and export that to Excel.  A sample of the file is below:
  
  John Doe 1     123 Any Street
  
                       Any Town, Any State 11111
  
                      JohnDoe1@Domain.com <mailto:JohnDoe1@Domain.com>
  
  John Doe 2    456 Any Street
  
                      Any Town, Any State 22222
  
                     JohnDoe2@Domain.com <mailto:JohnDoe2@Domain.com>
  
  John Doe 3    789 Any Street
  
                      Any Town, Any State 33333
  
                     JohnDoe3@Domain.com <mailto:JohnDoe3@Domain.com>
  
  I want it to look like this outputted into Excel:
  
  John Doe 1     JohnDoe1@Domain.com <mailto:JohnDoe1@Domain.com>
  
  John Doe 2     JohnDoe2@Domain.com <mailto:JohnDoe2@Domain.com>
  
  John Doe 3     JohnDoe3@Domain.com <mailto:JohnDoe3@Domain.com>
  
  If I can only get just the email addresses in a column form, that would work just fine.  Thanks for the help onthis.
  
  Michael

  ---

  Doug Robbins - Word MVP dkr[atsymbol]mvps[dot]org

  • Marked as answer by Sally Tang Thursday, April 21, 2011 6:19 AM

  Friday, April 15, 2011 8:48 PM