Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / March 2008

Tip: Looking for answers? Try searching our database.

N word, can I pull email addresses from the document then email?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
foureyesneenee - 31 Mar 2008 17:21 GMT
If I have 200 names, addresses then email addresses.  typed in paragraph
format.  I want to do a mail merge, so, I need word to pull each name and
address to start each letter, I also need it to personalize by saying Dear
John Doe, then, I want to email each letter, so 1. is there a way to tell
word to pull out each email address (200) to start a email? 2. Is there a way
to personalize the letters having word recognize the names to put after DEAR?
Rich/rerat - 31 Mar 2008 18:52 GMT
foureyesneenee,
After connecting your letter to a data source, insert the fields into your
letter, like this:

{mergefield first_name} {mergefield last_name}<ENTER>
{mergefield street_address}<ENTER>
{mergefield city_address}, {mergefield state_address} {mergefield
zip_code}<ENTER>
<ENTER>
Dear {mergefield first_name} {mergefield first_name},
(Your Letter Text)

Then Merge to New Document> Check the individual letters for errors or
necessary changes> Print.
You can also save the original mail-merge document as a "template" for
future use.

(Many individuals recommend that you do not use an "Address Block", but
insert the individual fields for street, city, etc...)

Signature

Add MS to your News Reader: news://msnews.microsoft.com
Rich/rerat
(RRR News)    <message rule>
<<Previous Text Snipped to Save Bandwidth When Appropriate>>

If I have 200 names, addresses then email addresses.  typed in paragraph
format.  I want to do a mail merge, so, I need word to pull each name and
address to start each letter, I also need it to personalize by saying Dear
John Doe, then, I want to email each letter, so 1. is there a way to tell
word to pull out each email address (200) to start a email? 2. Is there a
way
to personalize the letters having word recognize the names to put after
DEAR?
foureyesneenee - 31 Mar 2008 19:06 GMT
THANK YOU SO MUCH,

1 QUESTION, WHAT ABOUT THE EMAIL FIELD.  IS THERE A WAY TO PULL THE EMAIL
ADDRESSES, AND DUMP THEM INTO OUTLOOK TO EMAIL EACH INDIVIDUAL LETTER?

EXAMPLE:

JOHN DOE
1234 TREE STREET
WASHINGTON, DC 20000
JOHN_DOE@STREAM.ORG

YOU TOLD ME HOW TO MERGE THE LETTERS, AND ALSO CREATE THE DEAR FIELD.  BUT,
IS THERE A WAY TO PULL THE EMAIL ADDRESSES FROM THE DATA FIELD TO EMAIL EACH
INDIVIDUAL LETTER?

foureyesneenee

> If I have 200 names, addresses then email addresses.  typed in paragraph
> format.  I want to do a mail merge, so, I need word to pull each name and
> address to start each letter, I also need it to personalize by saying Dear
> John Doe, then, I want to email each letter, so 1. is there a way to tell
> word to pull out each email address (200) to start a email? 2. Is there a way
> to personalize the letters having word recognize the names to put after DEAR?
Doug Robbins - Word MVP - 31 Mar 2008 21:02 GMT
When you execute the merge, one of the possible destinations is to email.
If you select that option, you will then be asked which field in the data
source contains the email addresses.

You said in your original post that you had "200 names, addresses then email
addresses.  typed in paragraph format."

You should select all of those paragraphs and use the Convert Text to Table
feature under the Tables menu to convert the document into a table with one
record on each row of the table.  You may need to insert a row at the top of
the table into the cells of which you enter the names of the merge fields
(if the first paragraph does not contain them).

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> THANK YOU SO MUCH,
>
[quoted text clipped - 25 lines]
>> to personalize the letters having word recognize the names to put after
>> DEAR?

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.