Solved

Microsoft word mail merger with word 2007 to send personal email using macro or VB

Posted on 2012-04-04
3
329 Views
Last Modified: 2012-04-19
Dear Praveen,
 
Microsoft word says that we should be able to do a Mail merge with Word 2007. Need to write a macro or VB code whichever is easy/faster. We have to send an urgent email to all members of say XYZ team  with a more personal note like say Dear Abraham(i.e first name).
 
Dear Firstname,
 
<content of the letter>
 
Sincerely,
XYZ Team.
 
Please let us know how can we do it. Any ideas, resources, sample code highly appreciated. Thanks in advance.
0
Comment
Question by:gudii9
  • 2
3 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37807677
What has this to do with MS Access?
If your merge data in Access?

<Microsoft word says that we should be able to do a Mail merge with Word 2007.>
Sure, just use the Mail Merge Wizard:
Mailings-->Start Mail Merge-->Start Mail Merge-->Step by step mail merge wizard...

<Need to write a macro or VB code whichever is easy/faster.>
Once the mail Merge wizard is run once, all you have to do is Merge the document for any other Mailings, so are you quite sure you need a Custom Macro or VBA to do this...

How good are you with VBA/Macros?
See here for links to threads on this here:
http://www.experts-exchange.com/searchResults.jsp?searchTerms=automate+Mail+mergs%2C+MS+Access&componentHtmlId=basicSearch&searchType=10

JeffCoachman
0
 
LVL 7

Author Comment

by:gudii9
ID: 37807759
Microsoft word Ribbon has the merge option right. Not sure how to use that.

>>so are you quite sure you need a Custom Macro or VBA to do this...


I am not  good in VBA/Macros, But if there is a easy way to do it .Please advise
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 500 total points
ID: 37807934
<Microsoft word Ribbon has the merge option right. Not sure how to use that.>
Then learning the subtleties of Mail Merge should be your first priority here, not "automation" (VBA/macros) or "emailing"...
make sense?
http://www.youtube.com/watch?v=_Lrn3tgwR08
http://office.microsoft.com/en-us/word-help/mail-merge-i-use-mail-merge-for-mass-mailings-RZ010277841.aspx
http://www.youtube.com/watch?v=_9ExKwXQ3KQ
...et al

<Not sure how to use that.>
Can you try?
It is fairly straightforward, ...(if you have everything set up already)

Again, do you really *Need* a macro...?
<But if there is a easy way to do it >
If you are not Good at VBA, then nothing in VBA will be "easy"
;-)

Also the Email portion of this complicates this even more...

Again, familiarize yourself with Mail Merge First.
Then decide if you need this "Automated".
If you do need the automation, then you will have to also learn VBA...
:-O
So then you can investigate the links I posted

...Emailing the Merged data is another topic altogether...

In other words, there are no easy answers here if you are new to mail merge.
:-(

JeffCoachman
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

This article describes how to use the Send to Mail Recipient command. The instructions apply generally to Office 2007 and later versions, but Microsoft® Word 2013 was used for the specific steps and figures.  What is Send to Mail Recipient? Send…
This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

773 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