Solved

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

Posted on 2012-04-04
3
332 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

695 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