Solved

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

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

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

707 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now