Solved

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

Posted on 2012-04-04
3
330 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

Shortcuts in Word Just the other day I had a training for Microsoft and they wanted me to show how well the new Windows and Office behaved on a touch device, which by the way is great, but it was only then that I realized that using keyboard shortc…
A few years ago I was very much a beginner at VBA, and that very much remains the case today.  I'll do my best to explain things as I go in the hope that other beginners can follow.  If you just want to check out a tool that creates a Select Case fu…
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
This Micro Tutorial well show you how to find and replace special characters in Microsoft Word. This is similar to carriage returns to convert columns of values from Microsoft Excel into comma separated lists.

829 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