PC Review


Reply
Thread Tools Rate Thread

Can a Form being Mailmerged to Word

 
 
kul
Guest
Posts: n/a
 
      3rd May 2010
I was trying to mailmerge some info from a form to a Word doc coz the form
includes info from various tables including a Lookup column. Can I mailmerge
a form to a Word doc as I normally do for a table? Thanks.
 
Reply With Quote
 
 
 
 
Gina Whipp
Guest
Posts: n/a
 
      4th May 2010
kul,

Not from the form but from the forms RecordSource. Have a look at *Super
Easy Word Merge* about half way down the page...

http://www.members.shaw.ca/AlbertKal.../msaccess.html

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"kul" <(E-Mail Removed)> wrote in message
news:38C463DF-31BD-4000-8747-(E-Mail Removed)...
I was trying to mailmerge some info from a form to a Word doc coz the form
includes info from various tables including a Lookup column. Can I mailmerge
a form to a Word doc as I normally do for a table? Thanks.

 
Reply With Quote
 
kul
Guest
Posts: n/a
 
      4th May 2010
Hi Gina,

Thanks for your message. However, it seems difficult. Can you explain about
it further? Appreciate it.

Kul

"Gina Whipp" wrote:

> kul,
>
> Not from the form but from the forms RecordSource. Have a look at *Super
> Easy Word Merge* about half way down the page...
>
> http://www.members.shaw.ca/AlbertKal.../msaccess.html
>
> --
> Gina Whipp
> 2010 Microsoft MVP (Access)
>
> "I feel I have been denied critical, need to know, information!" - Tremors
> II
>
> http://www.regina-whipp.com/index_files/TipList.htm
>
> "kul" <(E-Mail Removed)> wrote in message
> news:38C463DF-31BD-4000-8747-(E-Mail Removed)...
> I was trying to mailmerge some info from a form to a Word doc coz the form
> includes info from various tables including a Lookup column. Can I mailmerge
> a form to a Word doc as I normally do for a table? Thanks.
>

 
Reply With Quote
 
Gina Whipp
Guest
Posts: n/a
 
      5th May 2010
kul,

You're going to have to be more specific... Explain further about what?
Have you never worked with modules before?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"kul" <(E-Mail Removed)> wrote in message
news:34A99AA3-744F-40FC-8AB9-(E-Mail Removed)...
Hi Gina,

Thanks for your message. However, it seems difficult. Can you explain about
it further? Appreciate it.

Kul

"Gina Whipp" wrote:

> kul,
>
> Not from the form but from the forms RecordSource. Have a look at *Super
> Easy Word Merge* about half way down the page...
>
> http://www.members.shaw.ca/AlbertKal.../msaccess.html
>
> --
> Gina Whipp
> 2010 Microsoft MVP (Access)
>
> "I feel I have been denied critical, need to know, information!" - Tremors
> II
>
> http://www.regina-whipp.com/index_files/TipList.htm
>
> "kul" <(E-Mail Removed)> wrote in message
> news:38C463DF-31BD-4000-8747-(E-Mail Removed)...
> I was trying to mailmerge some info from a form to a Word doc coz the form
> includes info from various tables including a Lookup column. Can I
> mailmerge
> a form to a Word doc as I normally do for a table? Thanks.
>

 
Reply With Quote
 
kul
Guest
Posts: n/a
 
      6th May 2010
Hi Gina,

Yes, it's my first time working with the modules. Everything over there is
very new to me. I tried to follow the one line code instruction, but I'm not
sure what to do next and if I've got it right. Please help. Thanks.

Kul

"Gina Whipp" wrote:

> kul,
>
> You're going to have to be more specific... Explain further about what?
> Have you never worked with modules before?
>
> --
> Gina Whipp
> 2010 Microsoft MVP (Access)
>
> "I feel I have been denied critical, need to know, information!" - Tremors
> II
>
> http://www.regina-whipp.com/index_files/TipList.htm
>
> "kul" <(E-Mail Removed)> wrote in message
> news:34A99AA3-744F-40FC-8AB9-(E-Mail Removed)...
> Hi Gina,
>
> Thanks for your message. However, it seems difficult. Can you explain about
> it further? Appreciate it.
>
> Kul
>
> "Gina Whipp" wrote:
>
> > kul,
> >
> > Not from the form but from the forms RecordSource. Have a look at *Super
> > Easy Word Merge* about half way down the page...
> >
> > http://www.members.shaw.ca/AlbertKal.../msaccess.html
> >
> > --
> > Gina Whipp
> > 2010 Microsoft MVP (Access)
> >
> > "I feel I have been denied critical, need to know, information!" - Tremors
> > II
> >
> > http://www.regina-whipp.com/index_files/TipList.htm
> >
> > "kul" <(E-Mail Removed)> wrote in message
> > news:38C463DF-31BD-4000-8747-(E-Mail Removed)...
> > I was trying to mailmerge some info from a form to a Word doc coz the form
> > includes info from various tables including a Lookup column. Can I
> > mailmerge
> > a form to a Word doc as I normally do for a table? Thanks.
> >

 
Reply With Quote
 
Gina Whipp
Guest
Posts: n/a
 
      7th May 2010
I can't see where you are or what step you go stuck at... so you will have
to tell me what part you are up to.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"kul" <(E-Mail Removed)> wrote in message
news:4F4ACFE0-3908-4F83-94E8-(E-Mail Removed)...
Hi Gina,

Yes, it's my first time working with the modules. Everything over there is
very new to me. I tried to follow the one line code instruction, but I'm not
sure what to do next and if I've got it right. Please help. Thanks.

Kul

"Gina Whipp" wrote:

> kul,
>
> You're going to have to be more specific... Explain further about what?
> Have you never worked with modules before?
>
> --
> Gina Whipp
> 2010 Microsoft MVP (Access)
>
> "I feel I have been denied critical, need to know, information!" - Tremors
> II
>
> http://www.regina-whipp.com/index_files/TipList.htm
>
> "kul" <(E-Mail Removed)> wrote in message
> news:34A99AA3-744F-40FC-8AB9-(E-Mail Removed)...
> Hi Gina,
>
> Thanks for your message. However, it seems difficult. Can you explain
> about
> it further? Appreciate it.
>
> Kul
>
> "Gina Whipp" wrote:
>
> > kul,
> >
> > Not from the form but from the forms RecordSource. Have a look at
> > *Super
> > Easy Word Merge* about half way down the page...
> >
> > http://www.members.shaw.ca/AlbertKal.../msaccess.html
> >
> > --
> > Gina Whipp
> > 2010 Microsoft MVP (Access)
> >
> > "I feel I have been denied critical, need to know, information!" -
> > Tremors
> > II
> >
> > http://www.regina-whipp.com/index_files/TipList.htm
> >
> > "kul" <(E-Mail Removed)> wrote in message
> > news:38C463DF-31BD-4000-8747-(E-Mail Removed)...
> > I was trying to mailmerge some info from a form to a Word doc coz the
> > form
> > includes info from various tables including a Lookup column. Can I
> > mailmerge
> > a form to a Word doc as I normally do for a table? Thanks.
> >

 
Reply With Quote
 
kul
Guest
Posts: n/a
 
      10th May 2010
Hmm, I'm sorry that I really don't know how to start. But I was trying to
look for any kind of tutorials for the modules. Didn't succeed. Is there
anything I can read so that I can start working on the modules? I simply have
no idea what to do after adding a button/ icon to merge with Word. I went to
the Property Sheet and clicked onto "Code Builder" under the tab "Event" and
"Event Procedure". I tried to copy and paste what was mentioned at the
article you've recommended, but I don't know what's next. Please help. Thanks.

"Gina Whipp" wrote:

> I can't see where you are or what step you go stuck at... so you will have
> to tell me what part you are up to.
>
> --
> Gina Whipp
> 2010 Microsoft MVP (Access)
>
> "I feel I have been denied critical, need to know, information!" - Tremors
> II
>
> http://www.regina-whipp.com/index_files/TipList.htm
>
> "kul" <(E-Mail Removed)> wrote in message
> news:4F4ACFE0-3908-4F83-94E8-(E-Mail Removed)...
> Hi Gina,
>
> Yes, it's my first time working with the modules. Everything over there is
> very new to me. I tried to follow the one line code instruction, but I'm not
> sure what to do next and if I've got it right. Please help. Thanks.
>
> Kul
>
> "Gina Whipp" wrote:
>
> > kul,
> >
> > You're going to have to be more specific... Explain further about what?
> > Have you never worked with modules before?
> >
> > --
> > Gina Whipp
> > 2010 Microsoft MVP (Access)
> >
> > "I feel I have been denied critical, need to know, information!" - Tremors
> > II
> >
> > http://www.regina-whipp.com/index_files/TipList.htm
> >
> > "kul" <(E-Mail Removed)> wrote in message
> > news:34A99AA3-744F-40FC-8AB9-(E-Mail Removed)...
> > Hi Gina,
> >
> > Thanks for your message. However, it seems difficult. Can you explain
> > about
> > it further? Appreciate it.
> >
> > Kul
> >
> > "Gina Whipp" wrote:
> >
> > > kul,
> > >
> > > Not from the form but from the forms RecordSource. Have a look at
> > > *Super
> > > Easy Word Merge* about half way down the page...
> > >
> > > http://www.members.shaw.ca/AlbertKal.../msaccess.html
> > >
> > > --
> > > Gina Whipp
> > > 2010 Microsoft MVP (Access)
> > >
> > > "I feel I have been denied critical, need to know, information!" -
> > > Tremors
> > > II
> > >
> > > http://www.regina-whipp.com/index_files/TipList.htm
> > >
> > > "kul" <(E-Mail Removed)> wrote in message
> > > news:38C463DF-31BD-4000-8747-(E-Mail Removed)...
> > > I was trying to mailmerge some info from a form to a Word doc coz the
> > > form
> > > includes info from various tables including a Lookup column. Can I
> > > mailmerge
> > > a form to a Word doc as I normally do for a table? Thanks.
> > >

 
Reply With Quote
 
Gina Whipp
Guest
Posts: n/a
 
      11th May 2010
Step 1 import modules and forms into your database. Have you done that?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"kul" <(E-Mail Removed)> wrote in message
newsF8ADFE6-5BD0-4877-9E14-(E-Mail Removed)...
Hmm, I'm sorry that I really don't know how to start. But I was trying to
look for any kind of tutorials for the modules. Didn't succeed. Is there
anything I can read so that I can start working on the modules? I simply
have
no idea what to do after adding a button/ icon to merge with Word. I went to
the Property Sheet and clicked onto "Code Builder" under the tab "Event" and
"Event Procedure". I tried to copy and paste what was mentioned at the
article you've recommended, but I don't know what's next. Please help.
Thanks.

"Gina Whipp" wrote:

> I can't see where you are or what step you go stuck at... so you will
> have
> to tell me what part you are up to.
>
> --
> Gina Whipp
> 2010 Microsoft MVP (Access)
>
> "I feel I have been denied critical, need to know, information!" - Tremors
> II
>
> http://www.regina-whipp.com/index_files/TipList.htm
>
> "kul" <(E-Mail Removed)> wrote in message
> news:4F4ACFE0-3908-4F83-94E8-(E-Mail Removed)...
> Hi Gina,
>
> Yes, it's my first time working with the modules. Everything over there is
> very new to me. I tried to follow the one line code instruction, but I'm
> not
> sure what to do next and if I've got it right. Please help. Thanks.
>
> Kul
>
> "Gina Whipp" wrote:
>
> > kul,
> >
> > You're going to have to be more specific... Explain further about what?
> > Have you never worked with modules before?
> >
> > --
> > Gina Whipp
> > 2010 Microsoft MVP (Access)
> >
> > "I feel I have been denied critical, need to know, information!" -
> > Tremors
> > II
> >
> > http://www.regina-whipp.com/index_files/TipList.htm
> >
> > "kul" <(E-Mail Removed)> wrote in message
> > news:34A99AA3-744F-40FC-8AB9-(E-Mail Removed)...
> > Hi Gina,
> >
> > Thanks for your message. However, it seems difficult. Can you explain
> > about
> > it further? Appreciate it.
> >
> > Kul
> >
> > "Gina Whipp" wrote:
> >
> > > kul,
> > >
> > > Not from the form but from the forms RecordSource. Have a look at
> > > *Super
> > > Easy Word Merge* about half way down the page...
> > >
> > > http://www.members.shaw.ca/AlbertKal.../msaccess.html
> > >
> > > --
> > > Gina Whipp
> > > 2010 Microsoft MVP (Access)
> > >
> > > "I feel I have been denied critical, need to know, information!" -
> > > Tremors
> > > II
> > >
> > > http://www.regina-whipp.com/index_files/TipList.htm
> > >
> > > "kul" <(E-Mail Removed)> wrote in message
> > > news:38C463DF-31BD-4000-8747-(E-Mail Removed)...
> > > I was trying to mailmerge some info from a form to a Word doc coz the
> > > form
> > > includes info from various tables including a Lookup column. Can I
> > > mailmerge
> > > a form to a Word doc as I normally do for a table? Thanks.
> > >

 
Reply With Quote
 
kul
Guest
Posts: n/a
 
      13th May 2010
I guess I have got the form done based on the database (Table). However, how
can I import the modules? Please show me. Thanks a lot.


"Gina Whipp" wrote:

> Step 1 import modules and forms into your database. Have you done that?
>
> --
> Gina Whipp
> 2010 Microsoft MVP (Access)
>
> "I feel I have been denied critical, need to know, information!" - Tremors
> II
>
> http://www.regina-whipp.com/index_files/TipList.htm
>
> "kul" <(E-Mail Removed)> wrote in message
> newsF8ADFE6-5BD0-4877-9E14-(E-Mail Removed)...
> Hmm, I'm sorry that I really don't know how to start. But I was trying to
> look for any kind of tutorials for the modules. Didn't succeed. Is there
> anything I can read so that I can start working on the modules? I simply
> have
> no idea what to do after adding a button/ icon to merge with Word. I went to
> the Property Sheet and clicked onto "Code Builder" under the tab "Event" and
> "Event Procedure". I tried to copy and paste what was mentioned at the
> article you've recommended, but I don't know what's next. Please help.
> Thanks.
>
> "Gina Whipp" wrote:
>
> > I can't see where you are or what step you go stuck at... so you will
> > have
> > to tell me what part you are up to.
> >
> > --
> > Gina Whipp
> > 2010 Microsoft MVP (Access)
> >
> > "I feel I have been denied critical, need to know, information!" - Tremors
> > II
> >
> > http://www.regina-whipp.com/index_files/TipList.htm
> >
> > "kul" <(E-Mail Removed)> wrote in message
> > news:4F4ACFE0-3908-4F83-94E8-(E-Mail Removed)...
> > Hi Gina,
> >
> > Yes, it's my first time working with the modules. Everything over there is
> > very new to me. I tried to follow the one line code instruction, but I'm
> > not
> > sure what to do next and if I've got it right. Please help. Thanks.
> >
> > Kul
> >
> > "Gina Whipp" wrote:
> >
> > > kul,
> > >
> > > You're going to have to be more specific... Explain further about what?
> > > Have you never worked with modules before?
> > >
> > > --
> > > Gina Whipp
> > > 2010 Microsoft MVP (Access)
> > >
> > > "I feel I have been denied critical, need to know, information!" -
> > > Tremors
> > > II
> > >
> > > http://www.regina-whipp.com/index_files/TipList.htm
> > >
> > > "kul" <(E-Mail Removed)> wrote in message
> > > news:34A99AA3-744F-40FC-8AB9-(E-Mail Removed)...
> > > Hi Gina,
> > >
> > > Thanks for your message. However, it seems difficult. Can you explain
> > > about
> > > it further? Appreciate it.
> > >
> > > Kul
> > >
> > > "Gina Whipp" wrote:
> > >
> > > > kul,
> > > >
> > > > Not from the form but from the forms RecordSource. Have a look at
> > > > *Super
> > > > Easy Word Merge* about half way down the page...
> > > >
> > > > http://www.members.shaw.ca/AlbertKal.../msaccess.html
> > > >
> > > > --
> > > > Gina Whipp
> > > > 2010 Microsoft MVP (Access)
> > > >
> > > > "I feel I have been denied critical, need to know, information!" -
> > > > Tremors
> > > > II
> > > >
> > > > http://www.regina-whipp.com/index_files/TipList.htm
> > > >
> > > > "kul" <(E-Mail Removed)> wrote in message
> > > > news:38C463DF-31BD-4000-8747-(E-Mail Removed)...
> > > > I was trying to mailmerge some info from a form to a Word doc coz the
> > > > form
> > > > includes info from various tables including a Lookup column. Can I
> > > > mailmerge
> > > > a form to a Word doc as I normally do for a table? Thanks.
> > > >

 
Reply With Quote
 
Gina Whipp
Guest
Posts: n/a
 
      20th May 2010
You open the database and then select File... Get External Data... Import...
navigate to the database and select the Modules tab, and select the Modules
to import...

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"kul" <(E-Mail Removed)> wrote in message
news:61F2C941-B40B-42B1-91DA-(E-Mail Removed)...
I guess I have got the form done based on the database (Table). However, how
can I import the modules? Please show me. Thanks a lot.


"Gina Whipp" wrote:

> Step 1 import modules and forms into your database. Have you done that?
>
> --
> Gina Whipp
> 2010 Microsoft MVP (Access)
>
> "I feel I have been denied critical, need to know, information!" - Tremors
> II
>
> http://www.regina-whipp.com/index_files/TipList.htm
>
> "kul" <(E-Mail Removed)> wrote in message
> newsF8ADFE6-5BD0-4877-9E14-(E-Mail Removed)...
> Hmm, I'm sorry that I really don't know how to start. But I was trying to
> look for any kind of tutorials for the modules. Didn't succeed. Is there
> anything I can read so that I can start working on the modules? I simply
> have
> no idea what to do after adding a button/ icon to merge with Word. I went
> to
> the Property Sheet and clicked onto "Code Builder" under the tab "Event"
> and
> "Event Procedure". I tried to copy and paste what was mentioned at the
> article you've recommended, but I don't know what's next. Please help.
> Thanks.
>
> "Gina Whipp" wrote:
>
> > I can't see where you are or what step you go stuck at... so you will
> > have
> > to tell me what part you are up to.
> >
> > --
> > Gina Whipp
> > 2010 Microsoft MVP (Access)
> >
> > "I feel I have been denied critical, need to know, information!" -
> > Tremors
> > II
> >
> > http://www.regina-whipp.com/index_files/TipList.htm
> >
> > "kul" <(E-Mail Removed)> wrote in message
> > news:4F4ACFE0-3908-4F83-94E8-(E-Mail Removed)...
> > Hi Gina,
> >
> > Yes, it's my first time working with the modules. Everything over there
> > is
> > very new to me. I tried to follow the one line code instruction, but I'm
> > not
> > sure what to do next and if I've got it right. Please help. Thanks.
> >
> > Kul
> >
> > "Gina Whipp" wrote:
> >
> > > kul,
> > >
> > > You're going to have to be more specific... Explain further about
> > > what?
> > > Have you never worked with modules before?
> > >
> > > --
> > > Gina Whipp
> > > 2010 Microsoft MVP (Access)
> > >
> > > "I feel I have been denied critical, need to know, information!" -
> > > Tremors
> > > II
> > >
> > > http://www.regina-whipp.com/index_files/TipList.htm
> > >
> > > "kul" <(E-Mail Removed)> wrote in message
> > > news:34A99AA3-744F-40FC-8AB9-(E-Mail Removed)...
> > > Hi Gina,
> > >
> > > Thanks for your message. However, it seems difficult. Can you explain
> > > about
> > > it further? Appreciate it.
> > >
> > > Kul
> > >
> > > "Gina Whipp" wrote:
> > >
> > > > kul,
> > > >
> > > > Not from the form but from the forms RecordSource. Have a look at
> > > > *Super
> > > > Easy Word Merge* about half way down the page...
> > > >
> > > > http://www.members.shaw.ca/AlbertKal.../msaccess.html
> > > >
> > > > --
> > > > Gina Whipp
> > > > 2010 Microsoft MVP (Access)
> > > >
> > > > "I feel I have been denied critical, need to know, information!" -
> > > > Tremors
> > > > II
> > > >
> > > > http://www.regina-whipp.com/index_files/TipList.htm
> > > >
> > > > "kul" <(E-Mail Removed)> wrote in message
> > > > news:38C463DF-31BD-4000-8747-(E-Mail Removed)...
> > > > I was trying to mailmerge some info from a form to a Word doc coz
> > > > the
> > > > form
> > > > includes info from various tables including a Lookup column. Can I
> > > > mailmerge
> > > > a form to a Word doc as I normally do for a table? Thanks.
> > > >

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Embedded images not displaying in Word mailmerged emails send via Outlook 2007 BevanS Microsoft Outlook Discussion 0 10th Mar 2009 04:59 AM
How to send a mailmerged document (attachment) as private??? Ten Managbanag Microsoft Outlook Discussion 0 17th Nov 2008 03:26 PM
How to send attachment in mailmerged MicrosoftOutlook groupemail bsn Microsoft Outlook Discussion 1 4th Sep 2008 05:35 PM
why after mailmerged the data can not be read? =?Utf-8?B?QmVsbCBXYW4=?= Microsoft Excel Worksheet Functions 1 16th Mar 2006 08:31 PM
mailmerged document by using automation from VB.NET to OFFICE 2000 Karel Microsoft VB .NET 0 25th Feb 2004 07:32 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:20 PM.