WUGNET, the Windows User Group Network
Your Complete Resource Center for "The Best" in Shareware, Computing Tips and Support, Windows Industry News... and much more!
Home Forums Shareware Windows Tips Hot Offers FREE Newsletters Arcade Contact Us About Partners
Search WUGNET: RSS Feeds RSS Feeds Advertise with WUGNET    |    Shareware eBooks
HomeHome FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

mail merge without prompts

 
   Home -> Office -> MailMerge Fields RSS
Next:  Include section numbers in Table of Contents  
Author Message
carrol

External


Since: Mar 08, 2005
Posts: 17



(Msg. 1) Posted: Sat Nov 08, 2008 4:28 am
Post subject: mail merge without prompts
Archived from groups: microsoft>public>word>mailmerge>fields (more info?)

for offfice 2003 I have a button that is programmmed: On Error GoTo
Err_Command33_Click
On Error GoTo Err_Command33_Click
MergeNoPrompts "Articles of Incorporation"

DoCmd.DoMenuItem acFormBar, acRecordsMenu, 2, , acMenuVer70

Exit_Command33_Click:
Exit Sub

Err_Command33_Click:
MsgBox Err.Description
Resume Exit_Command32_Click

End Sub

so that when i click it, it automatically opens the doc art of inc and does
a mailmerge with the current record in access.

how do i do this in access/word 2007?

thank you!
Back to top
Login to vote
Doug Robbins - Word MVP

External


Since: Jul 14, 2006
Posts: 4210



(Msg. 2) Posted: Sun Nov 09, 2008 3:05 am
Post subject: Re: mail merge without prompts [Login to view extended thread Info.]
Archived from groups: microsoft>public>access>formscoding, others (more info?)

The code that you have posted is in Access, so you will be more likely to
get a response from an Access Newsgroup. Accordingly, I have crossposted
this response to the microsoft.public.access.formscoding newsgroup

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"carrol" <carrol.RemoveThis@discussions.microsoft.com> wrote in message
news:DF9E0435-EAFA-43C7-9480-BCEA658346E0@microsoft.com...
> for offfice 2003 I have a button that is programmmed: On Error GoTo
> Err_Command33_Click
> On Error GoTo Err_Command33_Click
> MergeNoPrompts "Articles of Incorporation"
>
> DoCmd.DoMenuItem acFormBar, acRecordsMenu, 2, , acMenuVer70
>
> Exit_Command33_Click:
> Exit Sub
>
> Err_Command33_Click:
> MsgBox Err.Description
> Resume Exit_Command32_Click
>
> End Sub
>
> so that when i click it, it automatically opens the doc art of inc and
> does
> a mailmerge with the current record in access.
>
> how do i do this in access/word 2007?
>
> thank you!
Back to top
Login to vote
Display posts from previous:   
       Home -> Office -> MailMerge Fields All times are: Eastern Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Categories:
 Windows XP
 Windows Vista
 Windows Other
  Office
 Office Other
 Security
 WinRAR
  • Home |
  • Shareware |
  • Windows Tips |
  • Hot Offers |
  • FREE Newsletters |
  • Arcade |
  • Forums |
  • eBooks |
  • About WUGNET |
  • Partners |
  • Contact

  • WUGNET Privacy Policy |
  • Link to WUGNET