Solved

Easy question for 100 points!

Posted on 1998-05-08
10
192 Views
Last Modified: 2013-12-25
I have an list  of email addresses and first names from people who have subscribed to my club.

How can I 'mail merge' my newsletters, so they use the recipient's first name?

ie
Dear Jonathan

Thank you for joining my club blah blah blah

Can I do this in a free programme? Can I do this sort of thing in a combination of Word 97 and Outlook Express?

Please let me know...

Kind regards


Jonathan
0
Comment
Question by:mindwave
  • 3
  • 3
  • 2
  • +2
10 Comments
 

Expert Comment

by:clsmaster
ID: 1855917
How are the E-Mail address and Names Stored and what are you gonna merge them to (E-Mail or printed document)
0
 

Author Comment

by:mindwave
ID: 1855918
They are only stored in a members html guestbook format, so they have to be manually entered again so I don't care what I have to import them into.

I will be using it for mail merging outbound emails .

Thank you for your interest...

Jonathan
0
 

Expert Comment

by:java_kevin
ID: 1855919
Do you mean that people subscribing to your club will have their names and email sent to you, then u put them together in some sort of a group name. Finally, you'll send articles to the members?
0
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 
LVL 2

Expert Comment

by:johnny99
ID: 1855920
I believe I have the answer, if I understand the question:

If you have a list where the names and the emails are distinguished by "<" characters, you can divide it up using Word's "Convert Text To Table" command (Table Menu). Simply use the "Separate Text At" option to split your list at each occurence of the "<" character...

For Example,

John Horner <johnny99@sydney.dialix.oz.au>
Some Guy <someguy@somedomain.com>

Splits up nicely into a table. Once you've separated them out, you should be able to use the fact that they're in a table, plus a bit of judicous Search/Replace to do what you need.

If not, there are some options in Excel 5, ("Text To Columns" from memory, don't have it on this machine) that may be able to help you...

If you can put the info into an HTML Table, then save as text, by the way, it will format the columns using whitepace, i.e. pushing the data around like so:

[viewed in Courier/Courier New these columns line up]

John Horner <johnny99@sydney.dialix.oz.au>  (nice guy)
Some Guy    <someguy@somedomain.com>        (complete dickhead)

Which may make it more susceptible to interpretation by Word/Excel.

johnny "Parse the salt" 99


0
 

Author Comment

by:mindwave
ID: 1855921
Thanks johnny99 but that's not what I need...

I don't care HOW I extract the names and emails. What I need to know is, assuming I have the first names and email addresses, how do I go about emailing my newsletter to hundreds of people, each getting their first name as the example below shows...

=================================================
MoneySaver Smart Shopper Alert 10th May 1998
Issue #1    May 10, 1998
Save Money & Get Stuff Free!!
http://www.moneysaver.com.au
=================================================

Hi johnny99

Thank you for joining the MoneySaver Club. This newsletter & many more offfers is at
http://www.moneysaver.com.au/newsletters/

In your newsletter this week:

1) Wharf warfare! Have your say!
2) Enjoy the best coffee from Alan for free
3) Getting 2 cds for free
4) Save $20 on a tune-up at Kmart Tyre & Auto
5) Free Sausage Software and a $535 bonus!

etc. etc.

What database do I enter the names and email addresses to then 'mail merge' outward bound emails?


Thank you,

I really appreciate your helping me!

Jonathan :-)
0
 
LVL 2

Expert Comment

by:johnny99
ID: 1855922
Hmmm,

I don't know of any software that will create and merge emails.

Word will of course create mail-merges, but then you'd have to cut and paste each one into an email. A databse would have the same problem.

My instinct is this can't be done with your resources, but I'd suggest you do a search in shareware.com or download.com with the right keywords and maybe there's something out there.

jh
0
 

Expert Comment

by:java_kevin
ID: 1855923
I understand your question now. I also agree that no email software has been able to provide this function.

You maybe can download a database program from either of the two sites. Remember the www prefix.
0
 

Author Comment

by:mindwave
ID: 1855924
Thanks guys.

I'm off the the shareware sites.

Jonathan
0
 
LVL 2

Expert Comment

by:johnny99
ID: 1855925
Remember the www prefix, JK? Want to try it without? Not all sites have www at the start of them... : )

jjjhhh
0
 
LVL 3

Accepted Solution

by:
hkp earned 100 total points
ID: 1855926
If you use Word 97, you can use the mail merge dialog.

1. Select "Tools" menu.
2. Select "Mail Merge..."
3. Select "Get Data".
4. Select "Use Address Book"

Now, there can be some differences in system responses, but this is the basic concepts. You should be able to select the "Outlook Express" address book from a list of possible address books.

5. Create your main document, by inserting field "First_name" into the document. There's a mail merge toolbar for these operations. It will look something like this:

"Dear <<First_name>>

Thank you for joining my club blah blah blah

Can I do this in a free programme? Can I do this sort of thing in a combination of Word 97 and Outlook Express?

Please let me know...

Kind regards


Jonathan "


I hope this is what you needed.
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
FAQ pages provide a simple way for you to supply and for customers to find answers to the most common questions about your company. Here are six reasons why your company website should have a FAQ page
The viewer will learn how to dynamically set the form action using jQuery.
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question