UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> How To Make Macro From Excel To Run Mail Merge-and Let Us Chose The Data In Excel To Be Merged, Office 2007    
 
   
Frank Situmorang
post Jun 16 2017, 09:34 PM
Post#1



Posts: 1,161
Joined: 10-June 10



Hello,

Sorry for being absent almost 4 years, the reason is I already moved to CA from Jakarta Indonesia, and I just got a survival job right now, so I do not have time to do office job. But since I was just elected as our Church Treasurer, so I want to automatize my issuing receipts to members.

Can anybody help me how to make a macro from Excel running word merging?

The following VBA of Word Macro:

ActiveDocument.MailMerge.MainDocumentType = wdCatalog
With ActiveDocument.MailMerge
.Destination = wdSendToNewDocument
.SuppressBlankLines = True
With .DataSource
.FirstRecord = wdDefaultFirstRecord
.LastRecord = wdDefaultLastRecord
End With
.Execute Pause:=False


I need to inform that the following is the range which is the dynamic range.
Attached File  People_need_receipt.jpg ( 407.67K )Number of downloads: 1

How can we make the dynamic range can be read from word when we running the Macro from my word template attached Attached File  receipt_sample.jpg ( 151.18K )Number of downloads: 1
. Macro should let us to ck which one should be printed in the range (see this picture) Attached File  Wordmacro.jpg ( 102.18K )Number of downloads: 0
and give us a chance to see the checking point in Cell J1 should be OK

Thank you for any help

Frank
Go to the top of the page
 
cheekybuddha
post Jun 17 2017, 01:56 PM
Post#2


UtterAccess VIP
Posts: 9,048
Joined: 6-December 03
From: Telegraph Hill


Hi Frank,

I'm not sure I can be of much help, but maybe this link can offer some ideas?

hth,

d

--------------------


Regards,

David Marten
Go to the top of the page
 
Frank Situmorang
post Jun 19 2017, 07:07 PM
Post#3



Posts: 1,161
Joined: 10-June 10



Thank you David, I will give it a try

Frank
Go to the top of the page
 
Frank Situmorang
post Jun 19 2017, 07:07 PM
Post#4



Posts: 1,161
Joined: 10-June 10



Thank you David, I will give it a try

Frank
Go to the top of the page
 
Frank Situmorang
post Yesterday, 01:45 PM
Post#5



Posts: 1,161
Joined: 10-June 10



Hi David,

I tried to write macro like this, but it does not work.

Sub Frank_1()
'
' Frank_1 Macro
'
'
ActiveDocument.MailMerge.OpenDataSource _
Name:="c:\Mentone_Treasurer\Mentone SDA Church Receipt of Tithe n Offerings_for Print.xlsm", _
Connection:="", _
SQLStatement:="SELECT * FROM `Receipt`", WHERE `Nama` <> '0' ORDER BY `Nama` ASC "
& ""
SubType:=wdMergeSubTypeAccess
End Sub


Could you help?

Thank you

Frank
Go to the top of the page
 
cheekybuddha
post Yesterday, 01:57 PM
Post#6


UtterAccess VIP
Posts: 9,048
Joined: 6-December 03
From: Telegraph Hill


Frank, I'll try and have a look - but I doubt I will any spare time before next week.

Other members may be able to assist in the meanwhile, I hope.

d

--------------------


Regards,

David Marten
Go to the top of the page
 
cheekybuddha
post Yesterday, 01:58 PM
Post#7


UtterAccess VIP
Posts: 9,048
Joined: 6-December 03
From: Telegraph Hill


The backticks [ ` ] in your SQL statement might be causing a problem.

--------------------


Regards,

David Marten
Go to the top of the page
 
cheekybuddha
post Yesterday, 01:59 PM
Post#8


UtterAccess VIP
Posts: 9,048
Joined: 6-December 03
From: Telegraph Hill


What's the native language/regional setting of your copy of Office?

--------------------


Regards,

David Marten
Go to the top of the page
 
Frank Situmorang
post Yesterday, 08:02 PM
Post#9



Posts: 1,161
Joined: 10-June 10



David,

English I think, but anyway can you teach where to look the regional language of my office. I do not think Indonesian can work for the Office.

Thank you for your further help.


Frank
Go to the top of the page
 
MadPiet
post Yesterday, 08:18 PM
Post#10



Posts: 1,984
Joined: 27-February 09



I would say use Albert Kallal's "Super Easy Word Merge" but it runs from Access... Not an option if you're using a Mac, (but who does that?!)
Go to the top of the page
 
Frank Situmorang
post Yesterday, 08:52 PM
Post#11



Posts: 1,161
Joined: 10-June 10



Mad Piet,

Is there anything that run from Excel Macro?

Thanks

Frank
Go to the top of the page
 
Frank Situmorang
post Yesterday, 08:52 PM
Post#12



Posts: 1,161
Joined: 10-June 10



Mad Piet,

Is there anything that run from Excel Macro?

Thanks

Frank
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    24th June 2017 - 12:17 AM