Doug
Mon Feb 05 14:29:22 CST 2007
I would suggest that you take a look at
fellow MVP Albert Kallal's "MergeSingleWord"
utility at:
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html
--
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
"Carol G" <cgeddes@shaw.ca> wrote in message
news:JKtxh.893745$1T2.526599@pd7urf2no...
> from 1 record to 1 merge, but something like. One merge filtered by "City"
> or possibly by "Type of Customer"
> etc.
>
>
> "Doug Robbins - Word MVP" <dkr@REMOVECAPSmvps.org> wrote in message
> news:O5hHXrJSHHA.996@TK2MSFTNGP02.phx.gbl...
>> Are you talking about merging the information from multiple records in
> your
>> database into multiple Word documents or just inserting the information
> from
>> one record at a time into a Word document.
>>
>> --
>> 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
>>
>> "Carol G" <cgeddes@shaw.ca> wrote in message
>> news:laqxh.876293$1T2.441612@pd7urf2no...
>> > Thanks,
>> > I was hoping learn how to do some of this in word (not just because of
> the
>> > name concatenation) but I wish to use the same query filtered with a
>> > userform for choices then merged. I don't know the capabilites or
>> > difficulties in using word for this.
>> > I managed to use an If Then Word Field with another one nested inside
>> > it
>> > to
>> > accomplish the concatenation on the page but it was difficult to keep
>> > track
>> > of, all lumped together that way.
>> > I am going to buy a manual in the next few days but could you direct me
> to
>> > some good sites to help me understand the Word objects and how they are
>> > put
>> > together?
>> > It seems awfully complicated compared to Access.
>> > Thanks for your help
>> > Carol
>> >
>> >
>> > "Doug Robbins - Word MVP" <dkr@REMOVECAPSmvps.org> wrote in message
>> > news:%2390KpnCSHHA.3500@TK2MSFTNGP05.phx.gbl...
>> >> Use IIF functions in a Query in Access to do the concatenating and
>> >> then
>> > use
>> >> that Query as the data source for you mail merge.
>> >>
>> >> --
>> >> 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
>> >>
>> >> "Carol G" <cgeddes@shaw.ca> wrote in message
>> >> news:6z9xh.882293$R63.294005@pd7urf1no...
>> >> >I use this function in an Access Report to Format Peoples names
>> >> >properly.
>> >> > I wish to merge a word letter with my Access query but I don't know
>> > where
>> >> > in
>> >> > Word I would place this code or something like it. Can I use a
> variable
>> > to
>> >> > hold my result, in place of the merge fields drop down list which
> just
>> >> > lists each field individually?
>> >> > Any help would be appreciated.
>> >> > Thanks,
>> >> > Carol
>> >> >
>> >> >
>> >> > Private Function Name_Concatenate()
>> >> >
>> >> > Dim strFullName As String
>> >> >
>> >> >
>> >> >
>> >> > If ComLaw = True Then
>> >> >
>> >> > strFullName = FName1 & " " & LName1 & " " & "and" & " " & FName2
>> >> > &
> "
>> > "
>> >> > &
>> >> > LName2
>> >> >
>> >> > Else
>> >> >
>> >> > If IsNull(FName2) Then
>> >> >
>> >> > strFullName = FName1 & " " & LName1
>> >> >
>> >> > Else
>> >> >
>> >> > strFullName = FName1 & " and " & FName2 & " " & LName1
>> >> >
>> >> > End If
>> >> >
>> >> > End If
>> >> >
>> >> >
>> >> >
>> >> > Name_Concatenate = strFullName
>> >> >
>> >> >
>> >> >
>> >> > End Function
>> >> >
>> >> >
>> >>
>> >>
>> >
>> >
>>
>>
>
>