Group:  Microsoft Word ยป microsoft.public.word.mailmerge.fields
Thread: mail merge without prompts

Geek News

mail merge without prompts
carrol 11/8/2008 12:28:00 PM
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!
Re: mail merge without prompts
"Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 11/8/2008 8:03:27 PM
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[ at ]discussions.microsoft.com> wrote in message
news:DF9E0435-EAFA-43C7-9480-BCEA658346E0[ at ]microsoft.com...
[Quoted Text]
> 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!


Home | Search | Terms | Imprint Contact
Newsgroups Reader - provided by WiredBox.Net