mail merge vba

[rakesh seebaruth]

Hello Guys,

Can anyone help me on this please.

I have my excel data sheet and my word document as per link below

https://www.dropbox.com/s/my62tw9jsfktwo9/fixedcharge16032018.xls?dl=0


https://www.dropbox.com/s/h5wb91ymd39h3tr/mailmargeflo1.docx?dl=0


My word document is already configured with the merge fields layout .I have to try mail merge on word but
unfortunately word application becomes "not responding" each time i try mail merge.

Can i have a vba code for the mail merge please.

your help will be very much appreciated

thanks/regards

rakesh

​

 

[Fluff]

Cross posted https://www.excelguru.ca/forums/showthread.php?8873-mail-merge-vba

Cross-Posting
While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[Fluff]

Also here https://www.ozgrid.com/forum/forum/help-forums/excel-vba-macros/1201120-mail-merge-vba

 

[rakesh seebaruth]

ok thanks for the advice

 

[rakesh seebaruth]

mail merge vba through record macro

hi guys

The following are recorded macro :-

Sub Macro1()
'
' Macro1 Macro
'
'
ActiveDocument.MailMerge.OpenDataSource Name:= _
"C:\Users\rakesh\Desktop\New folder (17)\fixedcharge16032018.xls", _
ConfirmConversions:=False, ReadOnly:=False, LinkToSource:=True, _
AddToRecentFiles:=False, PasswordDocument:="", PasswordTemplate:="", _
WritePasswordDocument:="", WritePasswordTemplate:="", Revert:=False, _
Format:=wdOpenFormatAuto, Connection:= _
"Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data Source=C:\Users\rakesh\Desktop\New folder (17)\fixedcharge16032018.xls;Mode=Read;Extended Properties=""HDR=YES;IMEX=1;"";Jet OLEDB:System database="""";Jet OLEDB:Registry Path="""";Jet OLEDB:Engine Type=35;Je" _
, SQLStatement:="SELECT * FROM `Sheet1$`", SQLStatement1:="", SubType:= _
wdMergeSubTypeAccess
End Sub

The above works fine. I can preview my letters. But unfortunately when i click on Finish and Merge .Word cannot complete mail merge the letters are not sent in new word document. Each time i get the error word is not responding.

Can you amend or add some vba codes in the recorded macro.

thanks/regards

rakesh

 

[Fluff]

Re: mail merge vba through record macro

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. (See rule#12 here: Forum Rules).
I have merged both threads

 

[rakesh seebaruth]

Re: mail merge vba through record macro

can i ask the same question on a new thread ?

 

[Fluff]

Re: mail merge vba through record macro

Have you read what I said in post#6?

 

[rakesh seebaruth]

Re: mail merge vba through record macro

ok my apologies