A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Adding an item at the end of each line



 
 
Thread Tools Display Modes
  #1  
Old August 25th, 2007, 04:44 PM posted to microsoft.public.word.docmanagement
Nicole Ward
external usenet poster
 
Posts: 1
Default Adding an item at the end of each line

I copy and pasted a column from Excel to Word. I need to put a semi-colon at
the end of each line so I can then copy and paste into my e-mail to send a
mass mailing. Any ideas how I can select the entire document and add the
semi-colon to the end of each line? I have 10,000 e-mail addresses and don't
want to do it by hand to each line.

Thank you!
--
Nicole Ward
  #2  
Old August 25th, 2007, 06:10 PM posted to microsoft.public.word.docmanagement
Beth Melton
external usenet poster
 
Posts: 2,566
Default Adding an item at the end of each line

Why did you move it from Excel? That is a better database for your email
addresses. Also, while I can tell you how to easily add a semicolon at the
end of each email address in Excel, you don't need to do this. :-) Instead
of trying to send an email to mass recipients on a single email, you should
send each person an individual email. This will help make sure your email
reaches the intended recipients. Many email programs will treat emails with
a massive list of email addresses in the message header as spam. (Not to
mention those who harvest email address for sending spam LOVE to get their
hands on these types of emails!) I'm also wondering if you really do have
10,000 email addresses and plan to use them all in the same message header
if you'd even be able to send it to all of them at once.

A better method is to use Mail Merge which will send the same email to each
individual - the result is 10,000 emails that you didn't have to manually
prepare yourself. It sounds like you already have your data source created
in Excel so the hard part is done. Just specify your main document is for
E-Mail Messages and use your Excel workbook as the data source. If you need
help on walking through the process then here's an article that contains
step-by-step instructions.
http://office.microsoft.com/en-us/he...349201033.aspx

Please post all follow-up questions to the newsgroup. Requests for
assistance by email cannot be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Coauthor of Word 2007 Inside Out:
http://www.microsoft.com/MSPress/boo...x#AboutTheBook

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/

"Nicole Ward" wrote in message
...
I copy and pasted a column from Excel to Word. I need to put a semi-colon
at
the end of each line so I can then copy and paste into my e-mail to send a
mass mailing. Any ideas how I can select the entire document and add the
semi-colon to the end of each line? I have 10,000 e-mail addresses and
don't
want to do it by hand to each line.

Thank you!
--
Nicole Ward



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:00 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.